1주차미션
테이블 (13)
agreement (Untitled8)
- Key — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- term_id (Key3) — bigint — 외래 키 → term.id — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
food_category (Untitled10)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(15)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
inquiry (Untitled11)
- id (Key) — bigint — 기본 키 — NOT NULL
- title (Field) — varchar(50)
- type (Field2) — varchar(20)
- body (Field3) — varchar(50)
- status (Field4) — varchar(15)
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
inquiry_reply (Untitled12)
- id (Key) — bigint — 기본 키 — NOT NULL
- admin_id (Field) — varchar(15)
- body (Field2) — varchar(50)
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
- inquiry_id (Key2) — bigint — 외래 키 → inquiry.id — NOT NULL
location (Untitled6)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- created_at (Field2) — datatime(6)
- updated_at (Field3) — datetime(6)
member (Untitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- gender (Field2) — varchar(20)
- age (Field3) — date
- address (Field4) — varchar(40)
- email (Field5) — varchar(40)
- phone_num (Field6) — varchar(40)
- total_point (Field7) — int
- status (Field8) — varchar(15)
- inactive_date (Field9) — datetime
- social_type (Field10) — varchar(10)
- created_at (Field11) — datetime(6)
- updated_at (Field13) — datetime(6)
member_notification (Untitled13)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- new_event (Field) — varchar(50)
- review_deadline (Field2) — datetime(6)
- inquiry_reply (Field3) — varchar(10)
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)
mission (Untitled4)
- id (Key) — bigint — 기본 키 — NOT NULL
- store_id (Key2) — bigint — 외래 키 → store.id — NOT NULL
- reward (Field) — int
- deadline (Field2)
- mission_spec (Field3)
- created_at (Field4)
- Field5
mission_member (Untitled3)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- misson_id (Key3) — bigint — 외래 키 → mission.id — NOT NULL
- store_id (Key22) — bigint — 외래 키 → mission.store_id — NOT NULL
- status (Field) — varchar(15)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
preference (Untitled7)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- category_id (Key3) — bigint — 외래 키 → food_category.id — NOT NULL
- food (Field) — varchar(20)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
review (Untitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- store_id (Key3) — bigint — 외래 키 → store.id — NOT NULL
- body (Field) — float
- score (Field2) — float
store (Untitled5)
- id (Key) — bigint — 기본 키 — NOT NULL
- location_id (Key2) — bigint — 외래 키 → location.id — NOT NULL
- name (Field) — varchar(20)
- address (Field2) — varchar(20)
- score (Field3) — float
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)
term (Untitled9)
- id (Key) — bigint — 기본 키 — NOT NULL
- title (Field) — varchar(20)
- body (Field2) — text
- optional (Field3) — location
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)