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)