ProdarxSrv-ERD

Tables (48)

ADIMGINFO_TBL

  • adimg_id — int — Primary key — NOT NULL — 광고 이미지
  • media — smallint — Primary key — NOT NULL
  • month — tinyint — Primary key — NOT NULL
  • day — tinyint — Primary key — NOT NULL
  • pan — smallint
  • myun — smallint — NOT NULL
  • jibang — smallint — NOT NULL
  • img_type — smallint
  • reg_month — tinyint
  • reg_day — tinyint
  • title — varchar(64)
  • ad_host — varchar(32)
  • input_type — tinyint
  • color — tinyint
  • b_thumb — tinyint
  • b_print — tinyint
  • b_real — tinyint
  • b_deliv — tinyint
  • deliverer_id — int
  • thumb_name — varchar(64)
  • print_name — varchar(64)
  • real_name — varchar(64)
  • real_hsize — int
  • real_vsize — int
  • x_pixel — int
  • y_pixel — int
  • x_resolution — int
  • y_resolution — int
  • xy_units — int
  • onoff_c — tinyint
  • onoff_m — tinyint
  • onoff_y — tinyint
  • onoff_k — tinyint
  • format — tinyint
  • hochul_stat — tinyint
  • hochul_id — int
  • org_img_id — int
  • save_count — smallint
  • ref_id — int
  • reg_pan — smallint
  • paper_date — char(8) — NOT NULL
  • regist_date — char(8) — NOT NULL
  • year — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • Field
  • Field2

BUNRYU1_TBL

  • bunryu_code — smallint — Primary key — NOT NULL
  • bunryu_name — varchar(32)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

BUNRYU2_TBL

  • bunryu_code — smallint — Primary key — NOT NULL
  • bunryu_name — varchar(32)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • Field

CLIPIMG_PERSON_TBL

  • img_id — int — Primary key — NOT NULL
  • media — int — NOT NULL
  • paper_date — char(10) — NOT NULL
  • title — varchar(512)
  • img_type — tinyint
  • input_type — tinyint
  • color — tinyint
  • cre_date — datetime
  • cre_user — varchar(64)
  • dummy1 — int
  • thumb_file — varchar(64)
  • x_pixel — int
  • y_pixel — int
  • x_resolution — int
  • y_resolution — int
  • real_sz — int
  • real_hsz — int
  • real_vsz — int
  • real_file — varchar(64)
  • bunryu1 — int
  • bunryu2 — int
  • Career — varchar(512)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CLIPIMG_TBL

  • img_id — int — Primary key — NOT NULL
  • title — varchar(256)
  • img_type — tinyint
  • input_type — tinyint
  • color — tinyint
  • onoff_c — tinyint
  • onoff_m — tinyint
  • onoff_y — tinyint
  • onoff_k — tinyint
  • hochul_stat — tinyint
  • hochul_id — int
  • uuid — varchar(16)
  • cre_date — datetime
  • cre_user — int
  • format — tinyint
  • b_thumb — tinyint
  • thumb_sz — int
  • dummy1 — tinyint
  • thumb_hsz — int
  • thumb_vsz — int
  • thumb_file — varchar(64)
  • ad_host — varchar(32)
  • x_pixel — int
  • y_pixel — int
  • x_resolution — int
  • y_resolution — int
  • xy_units — smallint
  • b_real — smallint
  • real_sz — int
  • real_hsz — int
  • real_vsz — int
  • real_file — varchar(64)
  • bunryu1 — int
  • bunryu2 — int
  • cre_username — varchar(64)
  • media — int — NOT NULL
  • year — int — NOT NULL
  • month — int — NOT NULL
  • day — int — NOT NULL
  • is_backup — smallint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

DEPT_TBL

  • DEPT_CODE — varchar(50) — Primary key — NOT NULL
  • DEPT_NAME — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

FILM_NOTE_TBL

  • id — int — NOT NULL
  • pubdate — datetime
  • note — varchar(1024)

FILM_TIME_TBL

  • id — int — NOT NULL
  • pubdate — datetime
  • id_media — tinyint
  • pan — tinyint
  • page — tinyint
  • film_time — varchar(4)

IMGINFO_TBL

  • img_id — int — Primary key — NOT NULL
  • media — smallint — Primary key — NOT NULL
  • month — tinyint — Primary key — NOT NULL
  • day — tinyint — Primary key — NOT NULL
  • pan — smallint — Primary key — NOT NULL
  • myun — smallint — Primary key — NOT NULL
  • jibang — smallint — Primary key — NOT NULL
  • img_loc — smallint
  • ad_img_id — int
  • title — varchar(64)
  • kisa_id — int
  • img_type — tinyint
  • input_type — tinyint
  • color — tinyint
  • onoff_c — tinyint
  • onoff_m — tinyint
  • onoff_y — tinyint
  • onoff_k — tinyint
  • hochul_stat — tinyint
  • hochul_id — int
  • uuid — varchar(16)
  • cre_date — datetime
  • cre_user — int
  • format — tinyint
  • b_thumb — tinyint
  • thumb_sz — int
  • dummy1 — tinyint
  • thumb_hsz — int
  • thumb_vsz — int
  • thumb_file — varchar(64)
  • ad_host — varchar(32)
  • x_pixel — int
  • y_pixel — int
  • x_resolution — int
  • y_resolution — int
  • xy_units — smallint
  • dummy2 — smallint
  • b_real — smallint
  • real_sz — int
  • real_hsz — int
  • real_vsz — int
  • real_file — varchar(64)
  • org_img_id — int
  • save_count — smallint
  • ref_id — int
  • reg_pan — smallint
  • status — tinyint
  • paper_date — char(8) — NOT NULL
  • org_real_file — varchar(64)
  • year — int
  • cms_group_id — varchar(16)
  • cms_image_id — varchar(16)
  • author_name — varchar(32)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

IMG_REF_TBL

  • id — int — Primary key — NOT NULL
  • real_file — varchar(64)
  • thumb_file — varchar(64)
  • preview_file — varchar(64)
  • save_count — smallint
  • ref_count — smallint
  • img_type — tinyint
  • input_type — tinyint
  • color — tinyint
  • onoff_c — tinyint
  • onoff_m — tinyint
  • onoff_y — tinyint
  • onoff_k — tinyint
  • cre_date — datetime
  • cre_user — int
  • format — tinyint
  • b_thumb — tinyint
  • thumb_sz — int
  • ad_host — varchar(32)
  • x_pixel — int
  • y_pixel — int
  • x_resolution — int
  • y_resolution — int
  • xy_units — smallint
  • b_real — smallint
  • real_sz — int
  • print_sz — int
  • s_month — tinyint
  • s_day — tinyint
  • s_media — smallint
  • real_hsz — int
  • real_vsz — int
  • kisasvr_id — int
  • is_backup — smallint
  • s_paper_date — char(8) — NOT NULL
  • org_real_file — varchar(64)
  • cms_group_id — varchar(16)
  • cms_image_id — varchar(16)
  • s_year — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

JIBANGCODE_TBL

  • CODE — tinyint — NOT NULL
  • NAME — varchar(50)
  • REMARK — varchar(50)
  • ANAME — nvarchar(50)

KSINFO_TBL

  • kisa_id — int — Primary key — NOT NULL
  • media — smallint — Primary key — NOT NULL
  • month — tinyint — Primary key — NOT NULL
  • day — tinyint — Primary key — NOT NULL
  • pan — smallint — NOT NULL
  • myun — smallint — NOT NULL
  • jibang — smallint — NOT NULL
  • dummy0 — smallint
  • image_id — int
  • title — varchar(64)
  • issue — varchar(32)
  • reg_time — datetime
  • reg_user — smallint
  • author_code — smallint
  • line_count — smallint
  • text_type — tinyint
  • dummy1 — tinyint
  • dummy2 — smallint
  • text_size — int
  • lst_date — datetime
  • lst_user — smallint
  • edit_count — smallint
  • dummy3 — tinyint
  • hochul_stat — tinyint — NOT NULL
  • hochul_id — int — NOT NULL
  • uuid — varchar(16)
  • out_type — tinyint
  • text_style — tinyint
  • save_count — smallint
  • org_kisa_id — int
  • kisa_file — varchar(64)
  • kindofsection — smallint
  • kindofkisa — smallint
  • kindofgrade — smallint
  • kisasvr_id — int
  • is_now — smallint
  • is_update — smallint
  • chulgo_type — tinyint
  • subNumber — varchar(6)
  • reg_pan — smallint
  • Orgkisasrv_id — int
  • is_backup — smallint
  • paper_date — char(8)
  • year — int
  • author_name — varchar(32)
  • cms_group_id — varchar(16)
  • cms_kisa_id — varchar(16)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

MASTERINFO_TBL

  • media — smallint — NOT NULL
  • weekday — tinyint — NOT NULL
  • myun — smallint — NOT NULL
  • jibang — smallint
  • dummy0 — char(10)
  • section — smallint
  • myun_code — smallint
  • dummy1 — char(10)
  • color — tinyint
  • lay_user — smallint
  • dj_user — smallint
  • ad_user — smallint
  • myun_remark — varchar(128)
  • ad_dansu — varchar(64)
  • ad_remark — varchar(128)
  • desk — smallint
  • chief — smallint
  • hosu_gap — smallint
  • date_gap — smallint
  • comp_gap — smallint
  • dummy4 — smallint
  • dj_pattern — smallint
  • head_pattern — smallint
  • save_date — datetime
  • dj_kppln_date — datetime
  • ad_kppln_date — datetime
  • pan0 — smallint
  • pan1 — smallint
  • pan2 — smallint
  • pan3 — smallint
  • pan4 — smallint
  • pan5 — smallint
  • pan6 — smallint
  • pan7 — smallint
  • pan8 — smallint
  • pan9 — smallint

MEDIACODE_TBL

  • CODE — smallint — NOT NULL
  • DISCODE — smallint
  • NAME — varchar(32)
  • width — int
  • height — int
  • t_margin — int
  • b_margin — int
  • l_margin — int
  • r_margin — int
  • landscape — tinyint
  • dummy0 — char(10)
  • dummy1 — smallint

MYUNINFO_TBL

  • myun_id — int — Primary key — NOT NULL
  • media — smallint — NOT NULL
  • m_month — tinyint — NOT NULL
  • m_day — tinyint — NOT NULL
  • m_pan — smallint — NOT NULL
  • m_myun — smallint — NOT NULL
  • m_jibang — smallint — NOT NULL
  • m_section — smallint
  • pan_code — smallint
  • myun_code — smallint
  • hosu — int
  • cre_date — datetime
  • cre_user — int
  • lst_date — datetime
  • lst_user — int
  • lay_user — int
  • dj_user — int
  • dj_kpang — tinyint
  • bridge — tinyint
  • dummy1 — smallint
  • dj_cre_date — datetime
  • dj_kpan_date — datetime
  • dj_kppln_date — datetime
  • dj_kpan_count — int
  • dj_save_count — int
  • dj_flag — tinyint
  • ad_user — int
  • ad_kpang — tinyint
  • ad_cre_date — datetime
  • ad_kpan_date — datetime
  • ad_kppln_date — datetime
  • ad_kpan_count — int
  • ad_save_count — int
  • out_count — int
  • ad_dansu — varchar(50)
  • ad_flag — tinyint
  • color — tinyint
  • myun_remark — varchar(50)
  • ad_remark — varchar(50)
  • desk — int
  • chief — int
  • dj_pattern — int
  • head_pattern — int
  • dj_lock — tinyint
  • dj_lock_user — int
  • ad_lock — tinyint
  • dummy2 — tinyint
  • ad_lock_user — int
  • myun_file — varchar(64)
  • dj_file — varchar(64)
  • ad_file — varchar(64)
  • save_date — datetime
  • out_myun — smallint
  • ripip — varchar(20)
  • is_backup — smallint
  • paper_date — char(8) — NOT NULL
  • prtTime_C — datetime
  • prtTime_M — datetime
  • prtTime_Y — datetime
  • prtTime_K — datetime
  • … +7

MYUNNAME_TBL

  • myun_code — smallint
  • dummy1 — smallint
  • myun_name — varchar(32)
  • myun_remark — varchar(32)

PANINFO_TBL

  • id — smallint — NOT NULL
  • pan_code — smallint
  • pan_name — varchar(32)

PLANINFO_TBL

  • media — smallint — NOT NULL
  • m_month — tinyint — NOT NULL
  • m_day — tinyint — NOT NULL
  • pan — smallint — NOT NULL
  • myun — smallint — NOT NULL
  • jibang — smallint — NOT NULL
  • kipan_flag — smallint
  • section — smallint
  • pan_code — smallint
  • myun_code — smallint
  • color — tinyint
  • bridge — tinyint
  • dummy1 — smallint
  • lay_user — int
  • dj_user — int
  • ad_user — int
  • myun_remark — varchar(128)
  • ad_dansu — varchar(64)
  • ad_remark — varchar(128)
  • desk — int
  • chief — int
  • hosu_gap — smallint
  • date_gap — smallint
  • comp_gap — smallint
  • dummy2 — smallint
  • dj_pattern — int
  • head_pattern — int
  • m_save_date — datetime — NOT NULL
  • dj_kppln_date — datetime
  • ad_kppln_date — datetime
  • paper_date — char(8) — NOT NULL
  • m_year — int

PTTNINFO_TBL

  • pattern_no — int — NOT NULL
  • patternID — int
  • media — smallint — NOT NULL
  • type — smallint
  • reg_code — int
  • reg_date — datetime
  • dj_patn_file — varchar(64)
  • mn_patn_file — varchar(64)
  • ad_patn_file — varchar(64)
  • remark — varchar(128)
  • pttn_type — int — NOT NULL
  • is_backup — smallint

RIPSVRINFO_TBL

  • ripid — int — NOT NULL
  • ripname — varchar(32)
  • ripip — varchar(20)
  • ripport — int
  • riptype — int
  • status — int
  • last_rip — datetime
  • process — int

SOJOINFO_TBL

  • sojo_id — int — Primary key — NOT NULL
  • media — smallint — Primary key — NOT NULL
  • month — char(10) — Primary key — NOT NULL
  • day — char(10) — Primary key — NOT NULL
  • pan — smallint — NOT NULL
  • myun — smallint — NOT NULL
  • jibang — smallint — NOT NULL
  • sojo_filename — varchar(64)
  • color — char(10)
  • job_status — char(10)
  • hochul_stat — tinyint — NOT NULL
  • hochul_id — int — NOT NULL
  • title — varchar(64)
  • usr_code — smallint
  • sojo_type — char(10)
  • dummy1 — smallint
  • uuid — char(10)
  • width — smallint
  • height — smallint
  • org_sojo_id — int
  • save_count — smallint
  • reg_pan — smallint
  • cre_date — datetime
  • is_backup — smallint
  • paper_date — char(8) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_AUTOPRINT

  • TID — int — Primary key — NOT NULL
  • PAN — dbo.tyPan
  • FLAGE — tinyint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_CHINEINFO

  • TID — int — Primary key — NOT NULL
  • MEDIA — dbo.snMedia — NOT NULL
  • MONTH — dbo.tyMonth
  • DAY — dbo.tyDay
  • JIBANG — dbo.snJibang
  • PAPER_DATE — char(8)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_CMSUSERKISA

  • kisa_id — int — NOT NULL
  • mediahub_id — varchar(32)
  • mediahub_siteid — varchar(32)
  • author — varchar(64)
  • reserved — varchar(64)
  • email — varbinary(64)

T_CUBEAUTHOR

  • CUBE_STORYID — varchar(36) — Primary key — NOT NULL
  • CUBE_SITESTORYID — varchar(16) — NOT NULL
  • CUBE_USER_ID — varchar(36) — NOT NULL
  • CUBE_USER_NAME — varchar(128) — NOT NULL
  • CUBE_USER_EMAIL — varchar(128)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_DANSUINFO

  • TID — int — Primary key — NOT NULL
  • NAME — nvarchar(25) — NOT NULL
  • H — int — NOT NULL
  • V — int — NOT NULL
  • W — int — NOT NULL
  • D — int — NOT NULL
  • SAVE_DATETIME — datetime
  • SAVE_USERNAME — nvarchar(25)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_ERROR_HISTORY

  • code — int — Primary key — NOT NULL
  • egroup — tinyint — Primary key — NOT NULL
  • comment — text — ext NUL
  • count — bigint
  • level — tinyint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_HOSU

  • HOSU_MONTH — tinyint — Primary key — NOT NULL
  • HOSU_DAY — tinyint — Primary key — NOT NULL
  • HOSU_CODE — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_HOSU_NEW

  • HOSU_MEDIA — tinyint — Primary key — NOT NULL
  • HOSU_YEAR — int — Primary key — NOT NULL
  • HOSU_MONTH — tinyint — Primary key — NOT NULL
  • HOSU_DAY — tinyint — Primary key — NOT NULL
  • HOSU_CODE — int — NOT NULL
  • HOSU_DUMMY — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_LINKITEM

  • TID — int — Primary key — NOT NULL
  • FCHINEID — int — Foreign key → T_CHINEINFO.TID — NOT NULL
  • PAN — dbo.tyPan
  • MYUN — dbo.tyMyun
  • YOSOID — int
  • YOSOKIND — tinyint
  • DTLINK — datetime
  • UIDCODE — dbo.nUIDCode
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_PRINTMYUN

  • FMYUNID — int — Primary key — NOT NULL
  • FCHINEID — int — Primary key — NOT NULL
  • PAN — dbo.tyPan
  • MYUN — dbo.tyMyun
  • COUNT — tinyint
  • PTYPE — dbo.tyPType
  • DTKPAN — datetime
  • SEPERATE — int
  • DTFILM — datetime
  • DTFILMC — datetime
  • DTFILMM — datetime
  • DTFILMY — datetime
  • DTFILMK — datetime
  • FILMCOUNT — tinyint
  • FILMCOUNTC — tinyint
  • FILMCOUNTM — tinyint
  • FILMCOUNTY — tinyint
  • FILMCOUNTK — tinyint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_PRINTSEND

  • TID — int — Primary key — NOT NULL
  • FPSTATUSID — int — Foreign key → T_PRINTSTATUS.TID — NOT NULL
  • FMYUNID — int — Foreign key → T_PRINTSTATUS.FMYUNID — NOT NULL
  • FCHINEID — int — Foreign key → T_PRINTSTATUS.FCHINEID — NOT NULL
  • SEPERATE — int
  • LINKSTATUS — tinyint
  • COUNT — tinyint
  • FLAGE — tinyint
  • PTYPE — dbo.tyPType
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_PRINTSTATUS

  • TID — int — Primary key — NOT NULL
  • FMYUNID — int — Foreign key → T_PRINTMYUN.FMYUNID — NOT NULL
  • FCHINEID — int — Foreign key → T_PRINTMYUN.FCHINEID — NOT NULL
  • RIPID — dbo.tyPType — NOT NULL
  • RIPNUM — tinyint
  • WORKTYPE — tinyint
  • KPANTYPE — tinyint
  • PAN — dbo.tyPan
  • MYUN — dbo.tyMyun
  • MIRROR — tinyint
  • NEGA — tinyint
  • SEPERATE — int
  • UIDCODE — dbo.nUIDCode
  • TILE_3 — tinyint
  • START_TIME — datetime
  • END_TIME — datetime
  • LINKSTATUS — tinyint
  • FLAGE — tinyint
  • OUTSEP — int
  • DTKPAN — datetime
  • DTFILM — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_SECTIONCODE

  • ID_SECTION — int — NOT NULL
  • C_SCODE1 — int
  • C_SCODE2 — int
  • C_SCODE3 — int
  • C_SC1NAME — nvarchar(255)
  • N_LEVEL — int
  • V_SCODE — varchar(8)
  • B_USEFLAG — char(1)
  • ID_MECHAE — smallint

T_SECURITY_EXPIRATION

  • ID_EXPIRE — tinyint — NOT NULL
  • EXPIRE_PERIOD_ACCOUNT — smallint — NOT NULL
  • EXPIRE_PERIOD_PASSWORD — smallint — NOT NULL
  • LOGIN_FAIL_COUNT — smallint — NOT NULL
  • IGNORE_CSPROGRAM_YN — char(1) — NOT NULL

T_SEQID

  • ID_TBLNUM — tinyint — Primary key — NOT NULL
  • V_TBLNAME — varchar(32)
  • ID_MAX — decimal(18, 0)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_SOFTWARE

  • ID_SOFTCODE — int — Primary key — NOT NULL
  • V_SOFTNAME — varchar(128) — NOT NULL
  • V_EXENAME — varchar(64)
  • N_RESERVED — int
  • C_UNINAME — char(32)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_SOLARTOLUNAR

  • TID — int — Primary key — NOT NULL
  • SOLAR_YEAR — int — Primary key — NOT NULL
  • SOLAR_MONTH — tinyint — Primary key — NOT NULL
  • SOLAR_DAY — tinyint — Primary key — NOT NULL
  • SOLAR_DATE — datetime — Primary key — NOT NULL
  • LUNAR_YEAR — int — NOT NULL
  • LUNAR_MONTH — tinyint — NOT NULL
  • LUNAR_DAY — tinyint — NOT NULL
  • YUNDAL — bit
  • GANJI — nvarchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_SYNCDESK

  • TID — int — Primary key — NOT NULL
  • FDESKID — int
  • SUBID — int
  • AUTHOR — varchar(64)
  • RESKIND — dbo.tyResKind
  • INDEX — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_SYNCINDEX

  • TID — int — Primary key — NOT NULL
  • FCHINEID — int — Foreign key → T_CHINEINFO.TID — NOT NULL
  • MYUN — dbo.tyMyun
  • MAX — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_SYNCYOSO

  • TID — int — Primary key — NOT NULL
  • FSYNCID — int — Foreign key → T_SYNCDESK.TID
  • FYOSOID — int
  • RESKIND — dbo.tyResKind
  • FLAGE — tinyint
  • DESC — text
  • ACTIVE — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_USERINFO

  • ID_USERCODE — int — Primary key — NOT NULL
  • C_USERID — varchar(32) — NOT NULL
  • C_PASSWORD — varchar(64) — NOT NULL
  • SALT — varchar(32) — NOT NULL
  • V_USERNAME — varchar(32) — NOT NULL
  • ID_PART — int
  • B_NOTUSE — tinyint
  • N_WORKTYPE — int
  • ID_MECHAE — int
  • EXTERN_AUTH — int
  • EMP_NO — varchar(10)
  • USE_SMS — smallint — NOT NULL
  • PASSWORD_DATE — datetime
  • FIRST_ADD_USERCODE — varchar(32)
  • FIRST_CREATE_DATE — datetime
  • LAST_CHANGE_USERCODE — varchar(32)
  • LAST_CHANGE_DATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_USERINFO_NPS

  • ID_USERCODE — int — NOT NULL
  • WelcomePath — nvarchar(255)
  • Favorites — text

T_USERINFO_SECURITY

  • ID_USERCODE — int — Primary key — NOT NULL
  • V_USERID — varchar(32) — NOT NULL
  • V_PASSWORD — varchar(64) — NOT NULL
  • SALT — varchar(32) — NOT NULL
  • V_USERNAME — varchar(32) — NOT NULL
  • V_EMAIL — varchar(255)
  • MEDIA — smallint
  • ID_PUBPART — smallint
  • ID_DUTYCODE — varchar(50)
  • ID_DUTYSUBCODE — smallint — NOT NULL
  • B_NOTUSE — smallint — NOT NULL
  • N_WORKTYPE — varchar(100) — NOT NULL
  • N_WORKDATABASE — varchar(20) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • FILLFACTOR — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

T_USERLEVEL

  • UL_ID — int — NOT NULL
  • USER_CODE — int
  • USER_NAME — varchar(128)
  • DEPT_CODE — int
  • LEVEL_ID — int
  • LEVEL_NAME — varchar(128)

USERLOGINCHECK_TBL

  • USER_CODE — bigint — NOT NULL
  • USER_ID — varchar(20) — NOT NULL
  • USER_NAME — nvarchar(50)
  • IP — varchar(15)
  • LOGIN_DATE — datetime
  • LOGIN_SUCCESS_CNT — smallint — NOT NULL
  • LOGIN_FAIL_CNT — smallint — NOT NULL
  • LOGIN_FAIL_DATE — datetime

USERLOGINHISTORY_TBL

  • USER_CODE — bigint — NOT NULL
  • USER_ID — varchar(20) — NOT NULL
  • USER_NAME — nvarchar(50)
  • IP — varchar(15)
  • LOGIN_DATE — datetime
  • LOGIN_SUCCESS_YN — char(2)

USERLOGIN_TBL

  • user_code — int — NOT NULL
  • sw_code — int
  • ip — varchar(50)