d

Tables (3)

BOARD (CopyOf유저)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • type (Field3) — NOT NULL
  • title (Field) — NOT NULL
  • contents (Field2) — NOT NULL
  • text_contents (Field5) — NOT NULL
  • state (Field6) — NOT NULL
  • views (Field7) — NOT NULL
  • notice (Field10) — NOT NULL
  • main (Field9) — NOT NULL
  • reg_dt (Field4) — NULL
  • upt_dt (Field8) — NULL
  • user_id (Key2) — NOT NULL — Foreign key → USER.id — NOT NULL

FILE (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • ori_file (Field) — NOT NULL
  • new_file (Field2) — NOT NULL
  • type (Field3) — NOT NULL
  • file_path (Field4) — NOT NULL
  • size (Field5) — NOT NULL
  • state (Field6) — NOT NULL
  • board_id (Key2) — NOT NULL — Foreign key → BOARD.id — NOT NULL

USER (유저)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Field) — NOT NULL
  • user_pw (Field2) — NOT NULL
  • user_name (Field5) — NOT NULL
  • authority (Field3) — NOT NULL
  • reg_dt (Field4) — NULL