week1_backend_UMC11th

Tables (7)

food_category (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK, Auto Increment
  • name (Field) — VARCHAR(50) — NOT NULL

member (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK, Auto Increment
  • email (Field2) — VARCHAR(100) — NOT NULL — UNIQUE
  • nickname (Field3) — VARCHAR(30) — NOT NULL
  • point (Field4) — INT — NOT NULL
  • created_at (Field5) — DATETIME — NOT NULL
  • updated_at (Field6) — DATETIME — NOT NULL
  • deleted_at (Field7) — DATETIME

member_mission (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK, Auto Increment
  • status (Field) — VARCHAR(20) — NOT NULL
  • accepted_at (Field2) — DATETIME — NOT NULL
  • completed_at (Field3) — DATETIME
  • member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL — FK
  • mission_id (Key3) — BIGINT — Foreign key → mission.id — NOT NULL — FK

mission (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK, Auto Increment
  • title (Field) — VARCHER(100) — NOT NULL
  • description (Field2) — VARCHAR(255) — NOT NULL
  • reward_point (Field3) — NOT NULL
  • started_at (Field4) — DATETIME — NOT NULL
  • ended_at (Field5) — DATETIME — NOT NULL
  • store_id (Key2) — BIGINT — Foreign key → store.id — NOT NULL — FK

region (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK, Auto Increment
  • name (Field) — VARCHAR(50) — NOT NULL

social_account (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK,Auto Increment
  • provider (Field) — VARCHAR(20) — NOT NULL
  • provider_user_id (Field3) — VARCHAR(100) — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL — FK

store (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK, Auto Increment
  • name (Field) — VARCHAR(100) — NOT NULL
  • address (Field2) — VARCHAR(255) — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL
  • food_category_id (Key4) — BIGINT — Foreign key → food_category.id — NOT NULL — FK
  • regions_id (Key3) — BIGINT — Foreign key → region.id — NOT NULL — FK