cosexpenseshare.md 1.64 KB

Edit Raw Blame History



cosexpenseshare


Rows (estimated): 0

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:51:56

Updated: 


Columns


#
Name
Type
Null
Key
Default
Extra
Comment


1
iIncrement
int
NO
PRI

auto_increment
自增列


2
sId
varchar(100)
NO


标准ID


3
sBrandsId
varchar(100)
NO


加工商ID


4
sSubsidiaryId
varchar(100)
NO


子公司ID


5
tCreateDate
datetime
NO

CURRENT_TIMESTAMP
DEFAULT_GENERATED
制单日期


6
sMakePerson
varchar(255)
NO


制单人


7
iOrder
int
YES


序号


8
bCheck
bit(1)
NO

b'0'

是否审核


9
bPrint
bit(1)
NO

b'0'

是否打印


10
bInvalid
bit(1)
NO

b'0'

是否作废


11
tCheckDate
datetime
YES


审核日期


12
sCheckPerson
varchar(255)
YES


审核人


13
sBillNo
varchar(255)
NO


单据号


14
sPeriodID
varchar(255)
YES


月份


15
sMemo
varchar(255)
YES


备注


16
sFormId
varchar(255)
YES


界面Id


17
dShareMoney
decimal(18,6)
NO

0.000000

分摊金额


Indexes


Name
Unique
Type
Columns


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.