UMC_4th

Tables (9)

Category

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • category — VARCHAR(225)
  • status — VARCHAR(225)
  • created_at — VARCHAR(225)
  • updated_at — VARCHAR(225)

MissionInfo (Missions)

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • region_id — INT — NOT NULL
  • description — TEXT
  • points_awarded — INT — NOT NULL
  • is_recurring — BOOLEAN — NOT NULL

StoreCategory

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL — Auto Increament
  • store_id — INT — Foreign key → Stores.id

StoreImage

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • store_id — BIGINT — Foreign key → Stores.id — NOT NULL
  • Image_url — TEXT — NOT NULL

StoreReview

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • store_id — BIGINT — Foreign key → Stores.id — NOT NULL — Auto Increament
  • user_id — BIGINT — Foreign key → Users.id — NOT NULL — Auto Increament

Stores

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • address — VARCHAR(255) — NOT NULL
  • score — DOUBLE
  • open_time (open_timd) — TIME
  • close_time — TIME

UserCategory

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • user_id — BIGINT — Foreign key → Users.id — NOT NULL
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL

UserMission

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • mission_id — BIGINT — Foreign key → MissionInfo.id — NOT NULL
  • is_completed — BOOLEAN
  • is_reviewd — BOOLEAN

Users

  • id — BIGINT — Primary key — NOT NULL — Auto Increament
  • username — VARCHAR(255) — NOT NULL — 유저 이름
  • email — VARCHAR(255) — NOT NULL — 유저 이메일
  • password_hash — VARCHAR(255) — NOT NULL — 유저 패스워드(해쉬값)
  • points — INT — 유저 포인트
  • status — VARCHAR(225) — 유저 상태(정상, 휴먼, 탈퇴)
  • created_at — VARCHAR(225)
  • updated_at — VARCHAR(225)