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