board
Tables (4)
address (주소)
- ID (주소ID) — BIGINT — Primary key — NOT NULL
- ID (글쓴이ID) — BIGINT — Foreign key → author.ID — NOT NULL
- notion (국가) — VARCHAR(255) — NOT NULL
- city (도시) — VARCHAR(255) — NOT NULL
author (회원(글쓴이))
- ID (글쓴이ID) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- name (이름) — VARCHAR(255)
post (게시글)
- ID (글ID) — BIGINT — Primary key — NOT NULL
- title (제목) — VARCHAR(255) — NOT NULL
- contents (내용) — VARCHAR(3000)
post_author_list (글쓴이와 글)
- ID (글과 글쓴이 ID) — BIGINT — Primary key — NOT NULL
- author_ID (글쓴이ID) — BIGINT — Foreign key → author.ID — NOT NULL
- post_ID (글ID) — BIGINT — Foreign key → post.ID — NOT NULL