erd
Tables (5)
auth (권한)
- auth_id (pk) — long — Primary key — NOT NULL
- Field
board (게시판)
- board_id (pk) — long — Primary key — NOT NULL
- board_pid (uk) — long — Primary key — NOT NULL
- subject (Field) — varchar
- contents (Field2) — Text
- view_count (Field3)
- Field4
category (카테고리)
- category_id (pk) — long — Primary key — NOT NULL
- category_name (Field) — varchar
- Field2
comments (댓글)
- comments_id (pk) — Primary key — NOT NULL
- comments_pid (Field)
- Field2
user (사용자)
- user_id (PK) — long — Primary key — NOT NULL
- user_name (Field) — varchar
- user_pw (Field2)
- user_nickname (Field3)