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)