思迅专卖店10/数据库字典/t sys emp

来自Blueidea
跳转至: 导航搜索
字段名 字段类型(长度) 是否为空 功能
vch_empno varchar(6) NO
vch_empname varchar(20) YES
ch_deptno char(2) YES
branch_no char(6) YES
vch_duty varchar(12) YES
vch_tel varchar(30) YES
ch_sex char(2) YES
dt_birthday datetime(2) YES
vch_id varchar(20) YES
vch_address varchar(60) YES
vch_idaddress varchar(60) YES
vch_email varchar(40) YES
contactman varchar(20) YES
contacttel varchar(20) YES
ch_state char(1) YES
join_date datetime(1) YES
dimission_date datetime(1) YES
marriage_state char(1) YES
favor varchar(50) YES
vch_memo varchar(60) YES
vch_operID varchar(6) YES
dt_operdate datetime(6) YES
ch_waiterflag char(1) YES
ch_saleflag char(1) YES
ch_outflag char(1) YES
ch_markflag char(1) YES
ch_operflag char(1) YES
vch_handtel varchar(20) YES
ch_storeflag char(1) YES
ch_stockflag char(1) YES
health_state char(40) YES