board
Tables (3)
Member (회원)
- id (Key) — Primary key — NOT NULL
- user_id (회원아이디) — varchar
- password (비밀번호) — varchar
- email (이메일) — varchar
- phone (핸드폰) — varchar
Photo (사진)
- id (Key) — Primary key — NOT NULL
- post_id (게시글아이디) — Foreign key → Post.id — NOT NULL
- member_id (회원아이디) — Foreign key → Post.member_id — NOT NULL
- upload_file_name (업로드 파일명) — varchar
- store_file_name (저장 파일명) — varchar
- write_time (작성시간) — timestamp
- update_time (수정시간) — timestamp
Post (게시글)
- id (Key) — Primary key — NOT NULL
- member_id (회원아이디) — Foreign key → Member.id — NOT NULL
- title (제목) — varchar
- content (내용) — varchar
- write_time (작성시간) — timestamp
- update_time (수정시간) — timestamp