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