board
Tables (5)
board (게시판)
- id (Key) — Primary key — NOT NULL
- name (Field)
- content (Field2)
- reg_id (Field3)
- reg_date (Field4)
- upd_date (Field5)
- upd_id (Field6)
- db_status (Field8)
- db_status (Field7)
- board_type (Field9) — String
img (이미지)
- id (Key) — Primary key — NOT NULL
- origin_name (Field)
- uuid_name (Field2)
- path (Field3)
- reg_date (Field6)
- upd_date (Field7)
- post_id (Key2) — Foreign key → post.Key — NOT NULL
post (게시물)
- Key — Primary key — NOT NULL
- title (Field)
- content (Field2)
- non_mem_nick (Field3)
- non_mem_pwd (Field4)
- upd_date (Field7)
- img_id (Field8)
- db_status (Field9)
- reg_id (Key2) — Foreign key → user.id — NOT NULL
- board_id (Key3) — Foreign key → board.id — NOT NULL
- db_status (Field5)
reply (댓글)
- id (Key) — Primary key — NOT NULL
- non_mem_nick (Field)
- non_mem_pwd (Field2)
- reg_date (Field5)
- upd_date (Field6)
- post_id (Key2) — Foreign key → post.Key — NOT NULL
- db_status (Field3)
user (유저)
- id (Key) — Primary key — NOT NULL
- account_id (Field)
- password (Field2)
- nickname (Field3)
- mail (Field4)
- reg_date (Field6)
- upd_date (Field7)
- db_status (Field5)