백 관통
테이블 (4)
게시판 (Board)
- BoardId (Key) — NOTNULL — 기본 키 — NOT NULL
- member_id (Key2) — NOTNULL — 외래 키 → 멤버.member_id — NOT NULL
- content (Field) — NOTNULL
- title (Field2) — NOTNULL
- create_at (Field3) — NOTNULL
- modefied_at (Field4) — NOTNULL
관광지 (Tourist_spot)
- spot_id (Key) — notnull — 기본 키 — NOT NULL
- name (Field) — notnull
- discription (Field2) — notnull
- phone (Field3) — notnull
- address (Field4) — NOTNULL
리뷰 (Review)
- BoardId (Key) — NOTNULL — 기본 키 — NOT NULL
- member_id (Key2) — NOTNULL — 외래 키 → 멤버.member_id — NOT NULL
- title (Field) — NOTNULL
- content (Field2) — NOTNULL
- image (Field3) — NOTNULL
- created_at (Field5) — NOTNULL
- modefied_at (Field6) — NOTNULL
- writer_name (Field7) — NOTNULL
- star (Field8) — NOTNULL
- spot_id (Key3) — notnull — 외래 키 → 관광지.spot_id — NOT NULL
멤버 (Member)
- member_id (Key) — NOTNULL — 기본 키 — NOT NULL
- member_email (Field) — NOTNULL
- member_pw (Field2) — NOTNULL
- member_name (Field3) — NOTNULL
- member_birth (Field4) — NOTNULL
- member_nickname (Field5) — NOTNULL
- member_introduce (Field6) — NOTNULL