week1
Tables (11)
User (사용자)
- id (Key) — bigint — Primary key — NOT NULL
- gender (Field) — varchar(20)
- birth (Field2) — varchar(20)
- address (Field3) — varchar(20)
- email (Field4) — varchar(20)
- completed_mission_num (Field5) — int
- point (Field6) — long
- phone_num (Field7) — varchar(20)
- created_at (Field8) — datetime(6)
- updated_at (Field9) — datetime(6)
- status (Field10) — varchar(15)
- inactive_date (Field11) — datetime
- auth_status (Field12) — varchar(20)
- nickname (Field13) — varchar(20)
- social_type (Field14) — varchar(20)
food_category (Untitled10)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(15)
- create_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
member_mission (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- status (Field) — varchar(15)
- created_at (Field2) — datetime(6)
- updated_at (Field3)
- user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- mission_id (Key22) — bigint — Foreign key → mission.id — NOT NULL
member_prefer (Untitled3)
- id (Key3) — bigint — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.id — NOT NULL
- category_id (Key2) — bigint — Foreign key → food_category.id — NOT NULL
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
mission (Untitled)
- id (Key2) — bigint — Primary key — NOT NULL
- store_id (Key) — bigint — Foreign key → store.id — NOT NULL
- completed (Field) — int
- deadline (Field2) — datetime
- mission_spec (Field3) — text
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)
qna (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- title (Field) — varchar(20)
- content (Field2) — text
- created_at (Field3) — datetime(6)
- updated_ar (Field4) — datetime(6)
- Field5
qnaImage (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- qna_id (Key2) — bigint — Foreign key → qna.id — NOT NULL
- image (Field) — varchar(20)
region (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
review (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
- user_id (Key3) — bigint — Foreign key → User.id — NOT NULL
- mission_num (Field) — int
- score (Field3) — int
- content (Field2) — text
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)
reviewImage (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- review_id (Key2) — bigint — Foreign key → review.id — NOT NULL
- image (Field) — varchar(20)
store (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- region_id (Key2) — bigint — Foreign key → region.id — NOT NULL
- start_time (Field) — varchar(20)
- end_time (Field2) — varchar(20)
- image (Field3) — varchar(30)
- score (Field4) — int
- address (Field5) — varchar(30)
- category (Field6) — varchar(20)
- created_at (Field7) — datetime(6)
- updated_at (Field8) — datetime(6)