数据库逻辑结构

Relation_3

M_ID\t int\t 11JX_SP\t varchar\t500

Company&Studio

QY_GZS_ID\t int\t 11QY_GZS_LX\t tinyint\t1QY_GZS_MC\t varchar\t50QY_GZS_BGDH varchar\t11QY_GZS_YX\t varchar\t50QY_GZS_TXDZ\t varchar\t100QY_GZS_JLNF\t datetime\tQY_GZS_ZGRS\t int\t 5QY_GZS_ZYJSRYRS\t int\t 5QY_GZS_WY_ZY\t varchar\t100QY_GZS_ZYCP\t varchar\t200QY_GZS_CPZYCL\t varchar\t500QY_GZS_CPLY\t varchar\t50QY_GZS_SZDQTHSL int\t 5QY_GZS_JGSD\t varchar\t50QY_GZS_JJXY\t varchar\t20QY_GZS_SCGM\t varchar\t20QY_GZS_CPXSFS\t varchar\t50QY_GZS_CPFWJZYS\t varchar\t30QY_GZS_QYJJ\t varchar\t1000

Picture

P_ID\t int\t 11P_TP\t varchar\t20P_PATH\t varchar\t200P_CC\t varchar\t20P_TT\t varchar\t500P_COLUMN\tvarchar\t200

Role

R_ID\t int\t 10R_NAME\t varchar\t50R_KEY\t varchar\t50R_STATUS\t int\t 10R_DESCRIPTION\tvarchar\t100R_CREATE_TIME\tdatetime\tR_UPDATE_TIME\tdatetime\t

Media

M_ID\t int\t 11M_LX\t int\t 38M_YSPM\t varchar\t100M_JLSJ\t datetime\tM_JLR\t varchar\t100M_SCFR\t varchar\t20M_CFDD\t varchar\t50M_SC\t varchar\t11M_ZTJL\t varchar\t500M_PATH\t varchar\t200M_COLUMN\tvarchar\t200

belong to

belongto

Relation_2

M_ID\t int\t 11GYP_SYGN_SYSP\tvarchar\t100GYP_SYGN_SYYP\tvarchar\t100GYP_ZZLC_ZZSP\tvarchar\t100GYP_ZZLC_ZZYP\tvarchar\t100GYP_SYCS_CSSP\tvarchar\t100GYP_SYCS_CSYP\tvarchar\t100

Crafts

GYP_ID\t int\t 11 GYP_BM\t varchar\t30GYP_MC_ZM\t varchar\t20GYP_MC_YM\t varchar\t20GYP_SCD_DW\t varchar\t20GYP_SCD_SCRXM\tvarchar\t20GYP_SCD_DQ\t varchar\t20GYP_SCD_LXFS varchar\t30GYP_SCD_SCDZ\tvarchar\t100GYP_SCD_SJND\tdatetime\tGYP_SCD_SYNX\tint\t 38GYP_CYZ_SF\t varchar\t20GYP_CYZ_MZ\t varchar\t8GYP_CYZ_XB\t varchar\t2GYP_LYD\t varchar\t100GYP_ZS_ZSFS\t varchar\t60GYP_ZS_ZTA\t varchar\t60GYP_ZS_MS\t varchar\t500GYP_ZS_GJZP\t varchar\t100GYP_ZS_GJZPJB\tvarchar\t100GYP_GGXT_ZTGG\tvarchar\t100GYP_GGXT_JBGG\tvarchar\t100GYP_DST_TP\t varchar\t100GYP_DST_SST\t varchar\t100GYP_CCX\t int\t 11GYP_ZZGJ_CGGJ\tvarchar\t100GYP_ZZGJ_ZYGJ\tvarchar\t100GYP_ZZCL_CZ\t varchar\t50GYP_ZZCL_CLMC\tvarchar\t100GYP_SYGN_SYCH\tvarchar\t60GYP_SYGN_SYSP\tvarchar\t100GYP_SYGN_SYYP\tvarchar\t100GYP_ZZLC_ZZSP\tvarchar\t100GYP_ZZLC_ZZYP\tvarchar\t100GYP_SYCS_CSSP\tvarchar\t100GYP_SYCS_CSYP\tvarchar\t100GYP_BZ\t varchar\t100GYP_FOLD_ID\t int\t 11GYP_DEL_FLAG int\t 38GYP_CREATE_TIME\tdatetime\tGYP_UPDATE_TIME\tdatetime\tGYP_DYR_XM\t varchar\t20GYP_DYR_LXFS varchar\t20GYP_DYR_DW\t varchar\t40GYP_DYR_WZZLR\tvarchar\t50GYP_DYR_TPCLR\tvarchar\t50GYP_DYR_SPCLR\tvarchar\t50GYP_DYR_TBSJ datetime\t

Relation_4

QY_GZS_ID\t int\t 11C_QYGZS\t int\t 11

Inheritor

C_ID\t int 11C_XM\t varchar\t20C_XB tinyint\t1C_MZ\t varchar\t20C_CSNY \t datetime\tC_WHCD\t varchar\t20C_JG varchar\t100C_LXFS\t varchar\t200C_LXDZ\t varchar\t100C_TSSY\t varchar\t100C_CYQSN varchar\t50C_SC\t varchar\t20C_SFZH\t varchar\t18C_ZSFJH\t varchar\t11C_WX\t varchar\t50C_QQ\t varchar\t15C_DZXX\t varchar\t100C_YB varchar\t6C_ZY varchar\t200C_GZDZ\t varchar\t200C_XYTJD varchar\t200C_FYRD\t varchar\t500C_ZYDBZP varchar\t500C_HJQK\t varchar\t500C_BZ\t varchar\t200C_GRJL\t varchar\t1000C_ZP\t varchar\t200C_CCRS\t int\t 11C_QYGZS\t int\t 11C_SCGX\t varchar\t50C_XTQSNF varchar\t20C_LXFS_LS varchar\t11C_LXDZ_LS varchar\t100C_XTXM\t varchar\t20C_LXFS_XT varchar\t11C_LXDZ_XT varchar\t100

Relation_5

U_ID int\t 10R_ID\t int\t 10

Instructional video

JX_ID\t int\t 11JX_LX\t varchar\t80JX_JSXM\t varchar\t50JX_JSXB\t varchar\t4JX_JSMZ\t varchar\t20JX_CSNY\t datetime\tJX_WHCD varchar\t20JX_JG\t varchar\t100JX_LXDH\t varchar\t11JX_XSTX\t varchar\t20JX_TXDZ\t varchar\t100JX_ZP\t varchar\t100JX_KCMC\t varchar\t50JX_YZ\t varchar\t20JX_GRJL\t varchar\t1000JX_CJZP\t varchar\t100JX_ZJSL\t varchar\t20JX_ZSC\t varchar\t20JX_SP\t varchar\t500JX_KJ\t varchar\t100JX_BZ\t varchar\t100

User

U_ID int\t 10U_NAME\t varchar\t100U_ACCOUNT_NAME varchar\t100U_PASSWORD\t varchar\t100U_DELETE_STATUS\t int\t 10U_LOCKED\t int\t 10U_DESCRIPTION\t varchar\t200U_CREDENTIALS_SALT\tvarchar\t500U_CREATOR_NAME\t varchar\t100U_CREATE_TIME\t datetime\tU_UPDATE_TIME\t datetime\t

Relation_1

P_ID\t int\t 11GYP_DST_TP\tvarchar\t100