UMC

Tables (7)

food_category (Untitled3)

  • PK (food_category_id) — BIGINT — Primary key — NOT NULL
  • (name) — VARCHAR
  • (created_at)

member (Untitled6)

  • PK (member_id) — BIGINT — Primary key — NOT NULL
  • (email) — VARCHAR
  • (name) — VARCHAR
  • (point) — INT
  • (created_at) — TIMESTAMP

member_mission (Untitled5)

  • PK (member_mission_id) — BIGINT — Primary key — NOT NULL
  • PK (mission_id2) — BIGINT — Foreign key → mission.PK — NOT NULL
  • PK (member_id) — BIGINT — Foreign key → member.PK — NOT NULL
  • (status) — VARCHAR
  • (completed_at) — TIMESTAMP

mission (Untitled4)

  • PK (mission_id) — BIGINT — Primary key — NOT NULL
  • (title) — VARCHAR
  • (description) — VARCHAR
  • (created_at) — TIMESTAMP

region (Untitled)

  • PK (region_id) — BIGINT — Primary key — NOT NULL
  • (name) — VARCHAR
  • (created_at) — TIMESTAMP

social_login (Untitled7)

  • PK (social_login_id) — BIGINT — Primary key — NOT NULL
  • PK (member_id) — BIGINT — Foreign key → member.PK — NOT NULL
  • (provider) — VARCHAR
  • (provider_user_id) — VARCHAR
  • (created_at) — TIMESTAMP

store (Untitled2)

  • PK (store_id) — BIGINT — Primary key — NOT NULL
  • PK (region_id) — BIGINT — Foreign key → region.PK — NOT NULL
  • PK (food_category_id) — BIGINT — Foreign key → food_category.PK — NOT NULL
  • PK (mission_id) — BIGINT — Foreign key → mission.PK — NOT NULL
  • (name) — VARCHAR
  • (address) — VARCHAR
  • (created_at) — TIMESTAMP