main-1
Tables (28)
CU_TB_REQ (Untitled20)
- Key — VARCHAR(32) — Primary key — NOT NULL
- Key2 — CHAR(4) — Primary key — NOT NULL
- Key3 — VARCHAR(7) — Primary key — NOT NULL
- Key4 — INT — Primary key — NOT NULL
- Field3 — VARCAHR(30)
- Field5 — VARCHAR(200)
- Field7 — INT
- Field8 — INT
- Field9 — VARCHAR(20)
- Field10 — VARCHAR(8)
- Field11 — VARCHAR(50)
- Field12 — INT
- Field13 — SMALLDATETIME
- Field14 — VARCHAR(200)
- Field15 — VARCHAR(200)
- Field16 — VARCHAR(200)
- Field17 — VARCHAR(200)
- Field18 — VARCHAR(200)
- Field19 — VARCHAR(200)
- Field20 — VARCHAR(200)
- Field21 — VARCHAR(200)
- Field22 — VARCHAR(200)
- Field23 — VARCHAR(200)
- Field24 — VARCHAR(200)
- Field25 — VARCHAR(200)
- Field26 — VARCHAR(200)
- Field27 — VARCHAR(200)
- Field28 — VARCHAR(200)
- Field29 — VARCHAR(200)
- Field30 — VARCHAR(200)
- Field31 — VARCHAR(200)
- Field32 — VARCHAR(200)
- Field33 — VARCHAR(200)
- Field34 — CHAR(1)
- Field35 — SMALLDATETIME
CU_TB_RES (Untitled21)
- Key — VARCHAR(32) — Primary key — NOT NULL
- Key2 — INT — Primary key — NOT NULL
- Key3 — INT — Primary key — NOT NULL
- Field4 — INT
- Field5 — VARCHAR(500)
- Field6 — DATETIME
- Field7 — VARCHAR(50)
- Field8 — CHAR(1)
- Field9 — CHAR(30)
DETEIL (Untitled2)
- Key (Key2) — VARCHAR(32) — Foreign key → main.Key — NOT NULL
MULTI (Untitled7)
- Key (Key2) — VARCHAR(32) — Foreign key → main.Key — NOT NULL
- Key — VARCHAR(3) — Foreign key → TB_TP_CODE.Key — NOT NULL
TB_JIBU
- Field — CHAR(4)
- Field2 — VARCHAR(300)
TB_TP_ACCESSCODE (Untitled3)
- Key — VARCHAR(32) — Primary key — NOT NULL
- Key2 — DATE — Primary key — NOT NULL
- Key3 — INT — Primary key — NOT NULL
TB_TP_APPLOG
- Field — VARCHAR(20)
- Field2 — VARCHAR(30)
- Field3 — VARCHAR(15)
- Field4 — VARCHAR(100)
- Field5 — VARCHAR(10)
- Field6 — SMALLDATETIME
TB_TP_CENTER
- Key — VARCHAR(20) — Primary key — NOT NULL
- Key2 — VARCHAR(30) — Primary key — NOT NULL
- Field2 — VARCHAR(20)
- Field9 — VARCHAR(50)
- Field4 — VARCHAR(10)
- Field5 — VARCHAR(20)
- Field6 — VARCHAR(50)
- Field7 — VARCHAR(10)
- Field8 — VARCHAR(20)
- Field10 — VARCHAR(50)
- Field11 — VARCHAR(10)
- Field12 — VARCHAR(20)
- Field13 — VARCHAR(50)
- Field14 — VARCHAR(10)
- Field15 — VARCHAR(20)
- Field16 — VARCHAR(50)
- Field17 — VARCHAR(50)
- Field18 — VARCAHR(50)
- Field19 — VARCHAR(50)
TB_TP_CODE (Untitled8)
- Key — VARCHAR(30) — Primary key — NOT NULL
TB_TP_FAULTY
- Field — INT
- Field2 — INT
- Field3 — SMALLDATETIME
TB_TP_HOLIDAY
- Field — VARCHAR(20)
- Field2 — DATE
- Field3 — DATE
- Field4 — SMALLDATETIME
TB_TP_IMGSEAL
- Key — INT — Primary key — NOT NULL
- Field2 — IMAGE
- Field3 — VARCHAR(200)
- Field4 — SMALLDATETIME
TB_TP_JOB_SIGN
- Field — VARCHAR(32)
- Field2 — IMAGE
- Field3 — VARCHAR(32)
- Field4 — SMALLDATETIME
TB_TP_LOGINLOG (Untitled13)
- Field — VARCHAR(20)
- Field2 — VARCHAR(15)
- Field3 — CHAR(2)
- Field4 — SMALLDATETIME
- Field5 — SMALLDATETIME
- Field6 — VARCHAR(100)
TB_TP_MCODE (Untitled12)
- Field — VARCHAR(20)
- Field2 — INT
- Field3 — VARCHAR(30)
- Field4 — CHAR(1)
- Field5 — VARCHAR(100)
- Field6 — DATETIME
- Field7 — VARCHAR(10)
- Field8 — VARCHAR(32)
TB_TP_REPORT (Untitled4)
- Key — VARCHAR(32) — Foreign key → main.Key — NOT NULL
- Key (Key2) — VARCHAR(30) — Foreign key → TB_TP_USERS.Key — NOT NULL
TB_TP_REPORTLOG (Untitled17)
- Field — VARCHAR(15)
- Field2 — VARCHAR(2000)
- Field3 — VARCHAR(16)
- Field4 — VARCHAR(15)
- Field5 — SMALLDATETIME
TB_TP_REPORT_TMP_NEW (Untitled14)
- Key — VARCHAR(32) — Primary key — NOT NULL
- Key2 — VARCHAR(30) — Primary key — NOT NULL
- Field — INT
- Field2 — INT
- Field3 — SMALLDATETIME
- Field4 — VARCHAR(1024)
- Field5 — VARCHAR(1024)
- Field6 — VARCHAR(4)
- Field7 — INT
- Field8 — INT
- Field9 — CHAR(1)
- Field10 — DATE
TB_TP_SEARCHLOG (Untitled11)
- Field — VARCHAR(20)
- Field2 — VARCHAR(15)
- Field3 — VARCHAR(50)
- Field4 — VARCHAR(2000)
- Field5 — SMALLDATETIME
TB_TP_SMS (Untitled18)
- Field — VARCHAR(20)
- Field2 — VARCHAR(20)
- Field3 — CHAR(1)
- Field4 — DATE
- Field5 — VARCHAR(20)
TB_TP_SMSMILI (Untitled15)
- Field — VARCHAR(20)
- Field2 — SMALLDATETIME
- Field3 — CHAR(1)
- Field4 — SMALLTATETIME
- Field5 — VARCHAR(10)
- Field6 — VARCHAR(13)
- Field7 — VARCHAR(13)
TB_TP_SMS_RE (Untitled19)
- Field — CHAR(1)
- Field2 — DATE
- Field3 — VARCHAR(32)
TB_TP_STAT (Untitled16)
- Field — INT
- Field2 — VARCHAR(32)
- Field3 — VARCHAR(32)
- Field4 — DATE
- Field5 — SMALLDATETIME
- Field6 — SMALLDATETIME
- Field7 — VARCAHR(20)
- Field8 — VARCHAR(4)
- Field9 — VARCHAR(1024)
- Field10 — INT
- Field11 — VARCHAR(1024)
- Field12 — SMALLDATETIME
- Field13 — INT
- Field14 — VARCHAR(64)
TB_TP_USERS (Untitled5)
- Key — VARCHAR(16) — Primary key — NOT NULL
main (Untitled)
- Key — VARCHAR(32) — Primary key — NOT NULL
- Key (Key2) — VARCHAR(8) — Foreign key → 기관정보.Key — NOT NULL
- Key (Key3) — VARCHAR(32) — Foreign key → 취약계층검진DTL.Key — NOT NULL
- Key2 (Key23) — INT — Foreign key → 집단검진DTL.Key2 — NOT NULL
- Key2 (Key22) — DATE — Foreign key → TB_TP_ACCESSCODE.Key2 — NOT NULL
- Key3 (Key32) — INT — Foreign key → TB_TP_ACCESSCODE.Key3 — NOT NULL
기관정보 (Untitled6)
- Key — VARCHAR(7) — Primary key — NOT NULL
집단검진DTL (Untitled10)
- Key — VARCHAR(15) — Primary key — NOT NULL
- Key2 — INT — Primary key — NOT NULL
취약계층검진DTL (Untitled9)
- Key — VARCHAR(15) — Primary key — NOT NULL
- Key2 — INT — Primary key — NOT NULL