UMC_ch04

Tables (9)

Inquiry (Untitled4)

  • ID (Key) — int — Primary key — NOT NULL
  • User_id (Key2) — int — Foreign key → USER.ID — NOT NULL
  • Title (Field) — varchar(20)
  • Body (Field2) — varchar(200)
  • Field3

MISSION (Untitled2)

  • ID (Key) — int — Primary key — NOT NULL
  • Store_id (Key2) — int — Foreign key → STORE.ID — NOT NULL
  • Description (Field) — varchar(20)
  • reward (Field2) — int

NOTICE (Untitled3)

  • ID (Key) — int — Primary key — NOT NULL
  • User_id (Key2) — int — Foreign key → USER.ID — NOT NULL
  • Title (Field2) — varchar(20)
  • Body (Field3) — varchar(200)

PHONE_NUMBER (Untitled9)

  • ID (Key) — int — Primary key — NOT NULL
  • User_id (Key2) — int — Foreign key → USER.ID — NOT NULL
  • Authorization (Field2) — enum

REGION (Untitled8)

  • ID (Key) — int — Primary key — NOT NULL
  • Field
  • Field2

REVIEW (Untitled6)

  • ID (Key) — int — Primary key — NOT NULL
  • User_id (Key3) — int — Foreign key → USER.ID — NOT NULL
  • Store_id (Key2) — int — Foreign key → STORE.ID — NOT NULL
  • Body (Field) — varchar(20)
  • Rating (Field2) — enum

STORE (Untitled5)

  • ID (Key) — int — Primary key — NOT NULL
  • Region_id (Key2) — int — Foreign key → REGION.ID — NOT NULL
  • Name (Field3) — varchar(20)
  • Info (Field) — varchar(200)
  • Region (Field2) — enum

USER (Untitled)

  • ID (Key) — int — Primary key — NOT NULL
  • Email (Field) — varchar(20)
  • Password (Field2) — varchar(20)
  • Status (Field3) — enum
  • Name (Field4) — varchar(20)
  • Address (Field5) — varchar(20)
  • Gender (Field6) — enum
  • Birth (Field7) — varchar(20)
  • Point (Field8) — long

USER-MISSION (Untitled7)

  • ID (Key3) — int — Primary key — NOT NULL
  • User_id (Key) — int — Foreign key → USER.ID — NOT NULL
  • Mission_id (Key2) — int — Foreign key → MISSION.ID — NOT NULL
  • Status (Field2) — enum
  • created_at (Field) — datetime