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