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