백 관통

테이블 (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