UMC_과제

테이블 (12)

Untitled (stores)

  • Key (store_id) — BIGINT — 기본 키 — NOT NULL
  • Field (address) — VARCHAR(512)
  • Field (store_name) — VARCHAR(255)
  • Key (category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (categories)

  • Key (category_id) — BIGINT — 기본 키 — NOT NULL
  • Field (category_name) — VARCHAR(100)
  • Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL

Untitled (missions)

  • Key (mission_id) — BIGINT — 기본 키 — NOT NULL
  • Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
  • Field (mission_point) — INT
  • Field (status) — VARCHAR(20)
  • Field (target_amount) — INT

Untitled (reviews)

  • Key (review_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
  • Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — VARCHAR(512)
  • Field (created_at) — DATETIME
  • Field (star) — TINYINT

Untitled (review_images)

  • Key (review_image_id) — BIGINT — 기본 키 — NOT NULL
  • Key (review_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (image_url) — VARCHAR(512)

Untitled (replies)

  • Key (reply_id) — BIGINT — 기본 키 — NOT NULL
  • Key (review_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
  • Field (content) — VARCHAR(512)
  • Field (created_at) — DATETIME

Untitled (store_hours)

  • Key (store_hour_id) — BIGIINT — 기본 키 — NOT NULL
  • Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (day_of_week) — TINYINT
  • Field (open_time) — TIME
  • Field (close_time) — TIME
  • Field (is_day_off) — BOOLEAN

Untitled (inquiries)

  • Key (inquiry_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (content) — VARCHAR(512)
  • Field (status) — VARCHAR(100)
  • Field (created_at) — DATETIME

Untitled (inquiry_images)

  • Key (inquiry_image_id) — BIGINT — 기본 키 — NOT NULL
  • Field (inquiry_image_url) — VARCHAR(512)
  • Key (inquiry_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (notices)

  • Key (notice_id) — BIGINT — 기본 키 — NOT NULL
  • Field (created_at) — DATETIME
  • Key (notice_category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
  • Field (is_read) — BOOLEAN

Untitled (notice_type)

  • Key (notice_category_id) — BIGINT — 기본 키 — NOT NULL
  • Field (notice_type_name) — VARCHAR(100)

users

  • Key (user_id) — BIGINT — 기본 키 — NOT NULL
  • Field (email) — VARCHAR(255)
  • Field (password) — VARCHAR(255)
  • Field (provider) — VARCHAR(20)
  • Field (name) — VARCHAR(100)
  • Field (gender) — VARCHAR(20)
  • Field (preference) — VARCHAR(100)
  • Field (address) — VARCHAR(512)
  • Field (birthdate) — DATE
  • Field (created_at) — DATETIME
  • Field (deleted_at) — DATETIME
  • Field (point) — INT
  • Field (allow_location_sevice) — BOOLEAN
  • Field (allow_marketing) — BOOLEAN
  • Field (allow_new_event_notice) — BOOLEAN
  • Field (allow_review_reply_notice) — BOOLEAN
  • Field (allow_inquiry_notice) — BOOLEAN
  • Field (is_mobile_authenticated) — BOOLEAN