썩집

테이블 (3)

MARKET 1 (Untitled2)

  • ID (Key) — NOTNULL — 기본 키 — NOT NULL
  • MARKET_NAME (Field) — NOTNULL
  • LOCATION (Field2) — NOTNULL
  • PHONENUMBER (Field3) — NOTNULL
  • MENU (Field4) — NULLABLE
  • REVIEW (Field5) — NULLABLE

REVIEW (Untitled4)

  • ID (Key) — NOTNULL — 기본 키 — NOT NULL
  • USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
  • MARKET_ID (Key3) — NOTNULL — 외래 키 → MARKET 1.ID — NOT NULL
  • RATE (Field) — NOTNULL
  • COMMENT (Field2) — NOTNULL
  • SOLUTION (Field3) — NOTNULL
  • RECOMMEND (Field4) — NULLALBE
  • FILTTERING_COMMENT (Field5) — NOTNULL

USER (Untitled)

  • ID (Key) — NOTNULL — 기본 키 — NOT NULL
  • EMAIL (Field2) — NOTNULL
  • NAME (Field3) — NOTNULL
  • NICKNAME (Field4) — NOTNULL
  • SEX (Field5) — NOTNULL
  • IMG_URL (Field6) — NULLABLE
  • REVIEW (Field7) — NULLABLE