syssupplierinventory.md 1.03 KB

Edit Raw Blame History



syssupplierinventory


脚本更新日期表


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 19:10:03

Updated: 


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO
UNI


唯一ID


3
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
创建时间1


4
sMakePerson
varchar(100)
NO


制单人1


5
iOrder
int
NO

0

排序


6
bSupplierInventory
bit(1)
NO


更新文件夹


Indexes


Name
Unique
Type
Columns


IndexU_gdslogininfo
✓
BTREE
sId


PRIMARY
✓
BTREE
iIncrement


Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.