1주차

테이블 (17)

Untitled (user_region_mission)

  • Key (user_id) — int — 외래 키 → user.Key — NOT NULL
  • Key (mission_id) — int — 외래 키 → mission.Key — NOT NULL
  • Key (region_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (mission_count) — int
  • Field (reward_point) — int

Untitled (user_mission)

  • Field (complete) — boolean
  • Field (complete_date) — datetime
  • Key (mission_id) — int — 외래 키 → mission.Key — NOT NULL
  • Key (user_id) — int — 외래 키 → user.Key — NOT NULL

Untitled (region)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(30)

Untitled (alarm_inquire_reply)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (title) — text
  • Field (body) — text
  • Key (alarm_id) — int — 외래 키 → alarm.Key — NOT NULL
  • Field (created_at) — datetime(6)

Untitled (alarm_review_reply)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (title) — text
  • Field (body) — text
  • Key (alarm_id) — int — 외래 키 → alarm.Key — NOT NULL
  • Field (created_at) — datetime(6)

Untitled (new_event)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (title) — text
  • Field (body) — title
  • Key (alarm_id) — int — 외래 키 → alarm.Key — NOT NULL
  • Field (created_at) — datetime(6)

alarm

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (is_confirmed) — boolean
  • Key (user_id) — int — 외래 키 → user.Key — NOT NULL

food_type

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (type) — varchar(20)

inquire

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (title) — varchar(20)
  • Field (text) — text
  • Field (image) — text
  • Field (created_at) — datetime(6)
  • Field (status) — varchar(10)
  • Key (user_id) — int — 외래 키 → user.Key — NOT NULL

inquire_reply

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (text) — text
  • Field (updated_at) — datetime(6)
  • Field (created_at) — datetime(6)
  • Key (inquire_id) — int — 외래 키 → inquire.Key — NOT NULL

mission

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (detail) — text
  • Field (deadline) — datetime
  • Field (store_type) — varchar(20)
  • Field (min_price) — int
  • Field (certification_num) — int
  • Field (reward_point) — int
  • Key (store_id) — int — 외래 키 → store.Key — NOT NULL
  • Key (region_id) — int — 외래 키 → Untitled.Key — NOT NULL

review

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (text) — text
  • Field (image) — text
  • Field (rating) — int
  • Key (store_id) — int — 외래 키 → store.Key — NOT NULL
  • Key (user_id) — int — 외래 키 → user.Key — NOT NULL

review_img

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (ing_url) — text
  • Key (review_id) — int — 외래 키 → review.Key — NOT NULL

review_reply

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (user_id) — int
  • Field (test) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Key (review_id) — int — 외래 키 → review.Key — NOT NULL

store

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar
  • Field (address) — text
  • Field (store_status) — varchar(10)
  • Field (food_type) — varchar(20)
  • Field (rating_avg) — float

user

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(20)
  • Field2 (gender) — varchar(10)
  • Field3 (email) — text
  • Field4 (phone_num) — text
  • Field5 (birth) — datetime(6)
  • Field6 (address) — text
  • Field (total_points) — int

user_food_type

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → user.Key — NOT NULL
  • Key (food_type_id) — int — 외래 키 → food_type.Key — NOT NULL