思迅专卖店10/数据库字典/t bd branch info
来自Blueidea
< 思迅专卖店10
wangyue88(讨论 | 贡献)2018-07-11T16:16:57的版本 (创建页面,内容为“{|class="Tablelist" |- !width=20%|字段名!!width=20%|字段类型(长度)!!width=20%|是否为空!!功能 |- |branch_no||char(6)||NO|| |- |branch_name||varchar(30)...”)
字段名 | 字段类型(长度) | 是否为空 | 功能 |
---|---|---|---|
branch_no | char(6) | NO | |
branch_name | varchar(30) | NO | |
property | char(1) | YES | |
branch_man | varchar(16) | YES | |
address | varchar(40) | YES | |
zip | varchar(10) | YES | |
branch_email | varchar(40) | YES | |
branch_tel | varchar(18) | YES | |
branch_fax | varchar(18) | YES | |
display_flag | char(1) | NO | |
area | numeric(10) | YES | |
trade_type | char(1) | YES | |
com_grant | char(1) | YES | |
account | char(1) | YES | |
com_init | char(1) | YES | |
init_date | datetime(1) | YES | |
indep_bal | char(1) | YES | |
dc_no | char(6) | YES | |
com_date_up | datetime(6) | YES | |
com_date_down | datetime(6) | YES | |
com_oper_up | char(4) | YES | |
com_oper_down | char(4) | YES | |
pi_limited | numeric(18) | YES | |
dec_rate | numeric(18) | YES | |
price_ratio | numeric(18) | YES | |
price_option | char(1) | YES | |
vip_flag | char(1) | YES | |
vip_quota | numeric(16) | YES | |
vip_type | char(1) | YES | |
acc_flag | char(1) | YES | |
query_local_flag | char(1) | YES | |
operator_flag | char(1) | YES | |
branch_clsno | varchar(6) | YES | |
zbtg_flag | char(1) | YES | |
version_flag | char(1) | NO | |
num_oper | varchar(6) | YES | |
query_self | char(1) | YES | |
price_reference | char(6) | YES | |
include_spec | char(1) | YES | |
branch_up | varchar(6) | YES |