week4

Tables (12)

Untitled (market)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (boss_num) — bigint
  • Field2 (name) — varchar(45)
  • Field3 (address) — text
  • Field4 (open) — tinyint
  • Field5 (ratings) — float
  • Field6 (created_at) — datetime
  • Field7 (updated_at) — datetime
  • Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar(45)
  • Field2 (d_day) — int
  • Field3 (created_at) — datetime
  • Field4 (updated_at) — datetime
  • Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (point) — int

Untitled (category)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field2 (created_at) — datetime
  • Field3 (updated_at) — datetime

Untitled (mission_of_me)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — pk
  • Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (progress) — tinyint
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — pk
  • Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — text
  • Field2 (ratings) — float
  • Field3 (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (description) — text
  • Field (created_at) — datetime
  • Field2 (updated_at) — datetime
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — bigint — Foreign key → Untitled.id — pk
  • Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (inquiry)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar(20)
  • Field2 (content) — text
  • Field (image) — text
  • Field
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • id (user_id) — bigint — Foreign key → user.id — pk

Untitled (inquiry_type)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (review_img)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (img_url) — text
  • Field2 (created_at) — datetime
  • Field (updated_at) — datetime
  • Field
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — bigint — Foreign key → Untitled.id — pk
  • Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (region)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field2 (created_at) — datetime
  • Field3 (updated_at) — datetime

alarm

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (is_confirmed) — tinyint
  • Field2 (created_at) — datetime
  • Field3 (updated_at) — datetime
  • Field4 (dtype) — varchar(10)
  • Field (title) — varchar(30)
  • Field (body) — text
  • id (user_id) — bigint — Foreign key → user.id — pk

user

  • id — bigint — Primary key — pk
  • Field2 (account_type) — varchar(10)
  • Field3 (user_id) — varchar(10)
  • Field4 (pw) — varchar(10)
  • Field5 (name) — varchar(10)
  • Field (gender) — tinyint
  • Field (birth) — varchar(10)
  • Field (address) — text
  • Field2 (point) — float
  • Field3 (created_at) — datetime
  • Field4 (updated_at) — datetime
  • Field (status) — tinyint
  • Field (inactive_date) — datetime