board
Tables (4)
ADDRESS (주소)
- ID (주소ID) — BIGINT — Primary key — NOT NULL
- AUTHOR_ID (글쓴이ID) — BIGINT — Foreign key → AUTHOR.ID — NOT NULL
- NATION (국가) — 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)
AUTHOR_POST_LIST (글_회원_목록)
- ID (중복글ID) — BIGINT — Primary key — NOT NULL
- AUTOHR_ID (글쓴이ID) — BIGINT — Foreign key → AUTHOR.ID — NOT NULL
- POST_ID (글ID2) — Foreign key → POST.ID — NOT NULL
POST (게시글)
- ID (글ID) — Primary key — NOT NULL
- TITLE (제목) — VATCHAR(255) — NOT NULL
- CONTENTS (내용) — VARCHAR(3000)