NCS_v1

Tables (6)

COMMON (Untitled4)

  • CODE_GRP (Key2) — Foreign key → STATS.Key — NOT NULL
  • VALUE (Field2)

CONTENTS (Untitled)

  • id (Key) — Primary key — NOT NULL
  • CODE_GRP (Key22) — Foreign key → COMMON.CODE_GRP — NOT NULL
  • TITLE (Field) — VARCHAR
  • CONTENT (Field2) — VARCHAR
  • PHOTO (Field5) — VARCHAR
  • SUB_TITLE (Field7) — VARCHAR
  • SEAT (Field3) — INT

NOTIFICATION (Untitled6)

  • PHOTO (Field)
  • REG_DT (Field2)

RESERVATION (Untitled2)

  • Key — Primary key — NOT NULL
  • id (Key2) — Foreign key → CONTENTS.id — NOT NULL
  • RANDOM_NO (Key3) — INT — Foreign key → USER.RANDOM_NO — NOT NULL
  • INIT_DT (Field) — DATETIME
  • END_DT (Field2) — DATETIME
  • USE_AT (Field3) — BOOL

STATS (Untitled5)

  • Key — Primary key — NOT NULL
  • COTENT_GROUP (Field)
  • VISITOR_CNT (Field2)

USER (Untitled3)

  • RANDOM_NO (Key) — INT — Primary key — NOT NULL
  • PRE_REV (Field) — BOOLEAN
  • AD_CNT (Field2) — INT
  • CD_CNT (Field3) — INT
  • REG_DT (Field4) — DATETIME