UMC_mission
Tables (13)
Food_category (Untitled10)
- id (Key) — Primary key — NOT NULL
- name (Field)
- created_at (Field2)
- updated_at (Field3)
Inquiry (Untitled2)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Member.id — NOT NULL
- category_id (Key3) — Foreign key → Inquiry_category.id — NOT NULL
- title (Field)
- body (Field2)
- created_at (Field3)
- updated_at (Field4)
Inquiry_category (Untitled12)
- id (Key) — Primary key — NOT NULL
- name (Field)
Inquiry_image (Untitled13)
- id (Key4) — Primary key — NOT NULL
- inquiry_id (Key) — Foreign key → Inquiry.id — NOT NULL
- image_url (Field)
- created_at (Field2)
- updated_at (Field3)
Member (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
- gender (Field9) — enum
- age (Field8)
- address (Field2)
- spec_address (Field3)
- status (Field5) — enum
- inactive_date (Field7)
- social_type (Field4)
- created_at (Field10)
- updated_at (Field6)
- email (Field12)
- point (Field11)
Member_Mission (Untitled5)
- id (Key) — Primary key — NOT NULL
- mission_id (Key4) — Foreign key → Mission.id — NOT NULL
- member_id (Key3) — Foreign key → Member.id — NOT NULL
- id (Key32) — Foreign key → Mission.id — NOT NULL
- status (Field) — enum
- created_at (Field2)
- updated_at (Field3)
Member_prefer (Untitled9)
- id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.id — NOT NULL
- category_id (Key3) — Foreign key → Food_category.id — NOT NULL
- created_at (Field)
- updated_at (Field2)
Mission (Untitled4)
- id (Key) — Primary key — NOT NULL
- store_id (Key2) — Foreign key → Store.id — NOT NULL
- id (Key3) — Foreign key → Store.cateogory_id — NOT NULL
- reward (Field)
- deadline (Field2)
- mission_spec (Field3)
- created_at (Field4)
- updated_at (Field5)
Region (Untitled7)
- id (Key) — Primary key — NOT NULL
- name (Field)
- created_at (Field2)
- updated_at (Field3)
Review (Untitled3)
- id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.id — NOT NULL
- store_id (Key3) — Foreign key → Store.id — NOT NULL
- id (Key32) — Foreign key → Store.cateogory_id — NOT NULL
- body (Field)
- score (Field2)
- created_at (Field4)
- updated_at (Field5)
Review_image (Untitled11)
- id (Key) — Primary key — NOT NULL
- review_id (Key2) — Foreign key → Review.id — NOT NULL
- id (Key32) — Foreign key → Review.id — NOT NULL
- image_url (Field)
- created_at (Field2)
- updated_at (Field3)
Store (Untitled6)
- id (Key) — Primary key — NOT NULL
- region_id (Key2) — Foreign key → Region.id — NOT NULL
- cateogory_id (Key3) — Foreign key → Store_category.id — NOT NULL
- name (Field)
- address (Field2)
- score (Field5)
- created_at (Field3)
- updated_at (Field4)
- category (Field6)
Store_category (Untitled8)
- id (Key) — Primary key — NOT NULL
- name (Field)
- created_at (Field2)
- updated_at (Field3)