board
Tables (4)
adress (주소)
- id (주소 ID) — bigint — Primary key — NOT NULL
- author_id (글쓴이 ID) — bigint — Foreign key → author.id — NOT NULL
- region (국가) — varchar(255)
- city (도시) — varchar(255)
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
- author_id (글쓴이 ID) — bigint — Foreign key → author.id — NOT NULL
- post_id (글ID) — bigint — Foreign key → post.id — NOT NULL
post (게시글)
- id (글ID) — bigint — Primary key — NOT NULL
- title (제목) — varchar(255) — NOT NULL
- contents (내용) — varchar(255)