community
Tables (3)
board
- board_id — long — Primary key — NOT NULL
- userid — string — Foreign key → user_info.userid — NOT NULL
- title — string — default "임시제목"
- content — string(2000) — NOT NULL — default "임시내용"
- create_date — timestamp — default now()
- Like — int — NOT NULL
- hit — int — NOT NULL
reply
- reply_id — long — Primary key — NOT NULL
- board_id — long — Foreign key → board.board_id — NOT NULL
- userid (userid2) — string — Foreign key → user_info.userid — NOT NULL
- reply_content — string(500) — NOT NULL
- reply_create_date — timestamp
- like — int
user_info
- userid — string — Primary key — NOT NULL
- password — string — NOT NULL
- email — string — NOT NULL
- nick_name — string — NOT NULL