ITDA
Tables (7)
ADMIN (Untitled)
- Key (ID) — NUMBER — Primary key
- Field (NICKNAME) — VARCHAR2(100)
- Field2 — VARCHAR2(100)
BOARD (Untitled5)
- FK (ID) — Primary key — NOT NULL
- Field (VIEWS)
- Field2 (IMG)
- Field3 (TITLE)
- Field4 (CONTENTS)
- FK (USER_ID) — Foreign key → USER.FK — NOT NULL
- Field (REG_DATE)
BOARD_COMMENT (Untitled7)
- PK (Key) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
- FK (ID) — Foreign key → BOARD.FK — NOT NULL
MODIFY_HISTORY (Untitled2)
- PK (ID) — NUMBER — Primary key — NOT NULL
- Field (MODIFY_DATE) — TIMESTAMP
- Field2 (BEFORE_TITLE) — VARCHAR2(200)
- Field3 (BEFORE_CONTENTS)
- FK (ADMIN_ID) — NUMBER — Foreign key → ADMIN.Key
- PK (NOTICE_ID) — NUMBER — Foreign key → NOTICE.PK — NOT NULL
NOTICE (Untitled3)
- PK (ID) — NUMBER — Primary key — NOT NULL
- Field (DEL_DATE) — TIMESTAMP
- Field2 (TITLE) — VARCHAR2(100)
- Field3 (CONTENTS)
- Field4 (REG_DATE) — TIMESTAMP
- Key (REG_ADMIN_ID) — NUMBER — Foreign key → ADMIN.Key
- Key (DEL_ADMIN_ID) — NUMBER — Foreign key → ADMIN.Key
RECOMMEND (Untitled6)
- FK (USER_ID) — Foreign key → USER.FK — NOT NULL
- FK (BOARD_ID) — Foreign key → BOARD.FK — NOT NULL
USER (Untitled4)
- FK (ID) — Primary key — NOT NULL
- Field (NICK_NAME)
- Field2 (TOKEN)