字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
pk_tm_mcorp |
单位月度工资总额计划主键 |
char(20) |
20 |
|
是 |
|
是 |
pk_corp |
公司主键 |
char(4) |
4 |
|
|
|
|
theyear |
年度 |
varchar(4) |
4 |
|
|
|
|
themonth |
月度 |
varchar(2) |
2 |
|
|
|
|
monthm |
月度总额 |
numeric(31,8) |
31 |
8 |
|
|
|
is_release |
是否发布 |
char(1) |
1 |
|
|
|
|
def2 |
def2 |
decimal(31,8) |
31 |
8 |
|
|
|
def3 |
def3 |
decimal(31,8) |
31 |
8 |
|
|
|
def4 |
def4 |
decimal(31,8) |
31 |
8 |
|
|
|
def5 |
def5 |
decimal(31,8) |
31 |
8 |
|
|
|
def6 |
def6 |
decimal(31,8) |
31 |
8 |
|
|
|
def1 |
def1 |
decimal(31,8) |
31 |
8 |
|
|
|
def7 |
def7 |
decimal(31,8) |
31 |
8 |
|
|
|
def8 |
def8 |
decimal(31,8) |
31 |
8 |
|
|
|
def9 |
def9 |
decimal(31,8) |
31 |
8 |
|
|
|
def10 |
def10 |
decimal(31,8) |
31 |
8 |
|
|
|
def11 |
def11 |
decimal(31,8) |
31 |
8 |
|
|
|
def12 |
def12 |
decimal(31,8) |
31 |
8 |
|
|
|
def13 |
def13 |
decimal(31,8) |
31 |
8 |
|
|
|
def14 |
def14 |
decimal(31,8) |
31 |
8 |
|
|
|
def15 |
def15 |
decimal(31,8) |
31 |
8 |
|
|
|
def16 |
def16 |
decimal(31,8) |
31 |
8 |
|
|
|
def17 |
def17 |
decimal(31,8) |
31 |
8 |
|
|
|
def18 |
def18 |
decimal(31,8) |
31 |
8 |
|
|
|
def19 |
def19 |
decimal(31,8) |
31 |
8 |
|
|
|
def20 |
def20 |
decimal(31,8) |
31 |
8 |
|
|
|
def21 |
def21 |
decimal(31,8) |
31 |
8 |
|
|
|
def22 |
def22 |
decimal(31,8) |
31 |
8 |
|
|
|
def24 |
def24 |
decimal(31,8) |
31 |
8 |
|
|
|
def23 |
def23 |
decimal(31,8) |
31 |
8 |
|
|
|
def25 |
def25 |
decimal(31,8) |
31 |
8 |
|
|
|
def26 |
def26 |
decimal(31,8) |
31 |
8 |
|
|
|
def27 |
def27 |
decimal(31,8) |
31 |
8 |
|
|
|
def28 |
def28 |
decimal(31,8) |
31 |
8 |
|
|
|
def29 |
def29 |
decimal(31,8) |
31 |
8 |
|
|
|
def30 |
def30 |
decimal(31,8) |
31 |
8 |
|
|
|
def31 |
def31 |
decimal(31,8) |
31 |
8 |
|
|
|
def32 |
def32 |
decimal(31,8) |
31 |
8 |
|
|
|
def33 |
def33 |
decimal(31,8) |
31 |
8 |
|
|
|
def34 |
def34 |
decimal(31,8) |
31 |
8 |
|
|
|
def35 |
def35 |
decimal(31,8) |
31 |
8 |
|
|
|
def36 |
def36 |
decimal(31,8) |
31 |
8 |
|
|
|
def37 |
def37 |
decimal(31,8) |
31 |
8 |
|
|
|
def38 |
def38 |
decimal(31,8) |
31 |
8 |
|
|
|
def39 |
def39 |
decimal(31,8) |
31 |
8 |
|
|
|
def40 |
def40 |
decimal(31,8) |
31 |
8 |
|
|
|
def41 |
def41 |
decimal(31,8) |
31 |
8 |
|
|
|
def42 |
def42 |
decimal(31,8) |
31 |
8 |
|
|
|
def43 |
def43 |
decimal(31,8) |
31 |
8 |
|
|
|
def44 |
def44 |
decimal(31,8) |
31 |
8 |
|
|
|
def45 |
def45 |
decimal(31,8) |
31 |
8 |
|
|
|
def46 |
def46 |
decimal(31,8) |
31 |
8 |
|
|
|
def47 |
def47 |
decimal(31,8) |
31 |
8 |
|
|
|
def48 |
def48 |
decimal(31,8) |
31 |
8 |
|
|
|
def49 |
def49 |
decimal(31,8) |
31 |
8 |
|
|
|
def50 |
def50 |
decimal(31,8) |
31 |
8 |
|
|
|
def51 |
def51 |
decimal(31,8) |
31 |
8 |
|
|
|
def52 |
def52 |
decimal(31,8) |
31 |
8 |
|
|
|
def53 |
def53 |
decimal(31,8) |
31 |
8 |
|
|
|
def54 |
def54 |
decimal(31,8) |
31 |
8 |
|
|
|
def55 |
def55 |
decimal(31,8) |
31 |
8 |
|
|
|
def56 |
def56 |
decimal(31,8) |
31 |
8 |
|
|
|
def57 |
def57 |
decimal(31,8) |
31 |
8 |
|
|
|
def58 |
def58 |
decimal(31,8) |
31 |
8 |
|
|
|
def59 |
def59 |
decimal(31,8) |
31 |
8 |
|
|
|
def60 |
def60 |
decimal(31,8) |
31 |
8 |
|
|
|
def61 |
def61 |
decimal(31,8) |
31 |
8 |
|
|
|
def62 |
def62 |
decimal(31,8) |
31 |
8 |
|
|
|
def63 |
def63 |
decimal(31,8) |
31 |
8 |
|
|
|
def64 |
def64 |
decimal(31,8) |
31 |
8 |
|
|
|
def65 |
def65 |
decimal(31,8) |
31 |
8 |
|
|
|
def66 |
def66 |
decimal(31,8) |
31 |
8 |
|
|
|
def67 |
def67 |
decimal(31,8) |
31 |
8 |
|
|
|
def68 |
def68 |
decimal(31,8) |
31 |
8 |
|
|
|
def69 |
def69 |
decimal(31,8) |
31 |
8 |
|
|
|
def70 |
def70 |
decimal(31,8) |
31 |
8 |
|
|
|
def71 |
def71 |
decimal(31,8) |
31 |
8 |
|
|
|
def72 |
def72 |
decimal(31,8) |
31 |
8 |
|
|
|
def73 |
def73 |
decimal(31,8) |
31 |
8 |
|
|
|
def74 |
def74 |
decimal(31,8) |
31 |
8 |
|
|
|
def75 |
def75 |
decimal(31,8) |
31 |
8 |
|
|
|
def76 |
def76 |
decimal(31,8) |
31 |
8 |
|
|
|
def77 |
def77 |
decimal(31,8) |
31 |
8 |
|
|
|
def78 |
def78 |
decimal(31,8) |
31 |
8 |
|
|
|
def79 |
def79 |
decimal(31,8) |
31 |
8 |
|
|
|
def80 |
def80 |
decimal(31,8) |
31 |
8 |
|
|
|
def81 |
def81 |
decimal(31,8) |
31 |
8 |
|
|
|
def82 |
def82 |
decimal(31,8) |
31 |
8 |
|
|
|
def83 |
def83 |
decimal(31,8) |
31 |
8 |
|
|
|
def84 |
def84 |
decimal(31,8) |
31 |
8 |
|
|
|
def85 |
def85 |
decimal(31,8) |
31 |
8 |
|
|
|
def86 |
def86 |
decimal(31,8) |
31 |
8 |
|
|
|
def87 |
def87 |
decimal(31,8) |
31 |
8 |
|
|
|
def88 |
def88 |
decimal(31,8) |
31 |
8 |
|
|
|
def89 |
def89 |
decimal(31,8) |
31 |
8 |
|
|
|
def90 |
def90 |
decimal(31,8) |
31 |
8 |
|
|
|
def91 |
def91 |
decimal(31,8) |
31 |
8 |
|
|
|
def92 |
def92 |
decimal(31,8) |
31 |
8 |
|
|
|
def93 |
def93 |
decimal(31,8) |
31 |
8 |
|
|
|
def94 |
def94 |
decimal(31,8) |
31 |
8 |
|
|
|
def95 |
def95 |
decimal(31,8) |
31 |
8 |
|
|
|
def96 |
def96 |
decimal(31,8) |
31 |
8 |
|
|
|
def97 |
def97 |
decimal(31,8) |
31 |
8 |
|
|
|
def99 |
def99 |
decimal(31,8) |
31 |
8 |
|
|
|
def100 |
def100 |
decimal(31,8) |
31 |
8 |
|
|
|
def98 |
def98 |
decimal(31,8) |
31 |
8 |
|
|
|
isapproved |
是否审批 |
smallint |
|
|
|
|
|