UMC_Week1_Mission

Tables (16)

Untitled (mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (restaurant_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — boolean
  • Field (created_at) — datetime(6)
  • Field (deadline) — datetime(6)
  • Field (point) — int

Untitled (in_progress)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Field (body) — text
  • Field (rating) — double

Untitled (food_category)

  • Key (id) — int — Primary key — NOT NULL
  • Key (restaurant_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL

Untitled (restaurant)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (district_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(30)

Untitled (category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20)

Untitled (district)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(10)

Untitled (review_picture)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (pic) — blob

Untitled (inquiry)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field (body) — text

Untitled (inquiry_picture)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (pic) — blob

Untitled (alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (created_at) — datetime(6)

Untitled (new_event)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field (body) — varchar(30)

Untitled (inquiry_reply)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field (body) — varchar(30)

Untitled2 (completed)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled2 (review_reply)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field (body) — varchar(30)

user

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (gender) — varchar(10)
  • Field2 (birth) — varchar(8)
  • Field (address) — varchar(40)
  • Field (email) — varchar(50)
  • Field2 (password) — varchar(50)
  • Field (num) — varchar(11)