sysbrands.md 1.53 KB

Edit Raw Blame History



sysbrands


公司


Rows (estimated): 1

Data size: 16.0 KB

Engine: InnoDB

Collation: utf8mb3_general_ci

Created: 2026-04-27 18:57:08

Updated: 2026-04-27 18:57:08


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
制单日期


4
sMakePerson
varchar(255)
NO


制单人


5
iOrder
int
NO

0

排序号


6
sParentId
varchar(100)
NO


父级ID


7
sName
varchar(255)
NO
UNI


公司名称


8
sShortName
varchar(255)
NO


公司简称


9
sNo
varchar(255)
NO
UNI


单位编号（登录账号根据单位编号作为前缀）


10
bVisible
bit(1)
NO

b'0'

是否作废


11
sIconUrl
varchar(255)
YES


公司图标


Indexes


Name
Unique
Type
Columns


IndexN_sysbrands

BTREE

sId, sName, sNo


IndexNo_sysbrands
✓
BTREE
sNo


IndexU_sysbrands
✓
BTREE
sId


IndexU_sysbrandsName
✓
BTREE
sName


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.