board
Tables (4)
address (국가)
- Key (id) — BIGINT — Primary key — NOT NULL
- 글쓴이ID (author_id) — BIGINT — Foreign key → author.글쓴이ID — NOT NULL
- 국가 (country) — VARCHAR(255)
- 도시 (city) — VARCHAR(255)
- 길거리 (street) — VARCHAR(255)
author (글쓴이)
- 글쓴이ID (id) — BIGINT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR(50) — NOT NULL
- 이름 (name) — VARCHAR(100)
- 비밀번호 (password) — VARCHAR(255) — NOT NULL
author_post (사용자게시글)
- id — BIGINT — Primary key — NOT NULL
- 글쓴이ID (author_id) — BIGINT — Foreign key → author.글쓴이ID — NOT NULL
- 게시글ID (post_id) — BIGINT — Foreign key → post.게시글ID — NOT NULL
post (게시글)
- 게시글ID (id) — BIGINT — Primary key — NOT NULL
- 제목 (title) — VARCHAR(255) — NOT NULL
- 내용 (contents) — VARCHAR(65535)