2
Tables (7)
favorite (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- favorite_category (Field) — Enum(Chinese, Korean ..)
- created_at (Field2) — datetime(6)
- deleted_at (Field3) — datetime(6)
- is_deleted (Field4) — boolean
member (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- gender (Field5) — Enum(MALE, FEMALE)
- age (Field7) — int
- phone_number (Field6) — varchar(20)
- point (Field2) — int
- created_at (Field3) — datetime(6)
- update_at (Field4) — datetime(6)
- is_deleted (Field8) — boolean
member_favorite (Untitled7)
- member_fav_id (Key) — bigint — Primary key — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.id — NOT NULL
- fav_id (Key2) — bigint — Foreign key → favorite.id — NOT NULL
- created_at (Field) — datetime(6)
- deleted_at (Field2) — datetime(6)
- is_deleted (Field3) — boolean
member_mission (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
- mission_id (Key22) — bigint — Foreign key → mission_list.store_id — NOT NULL
- status (Field) — Enum(progress, complete, fail)
- created_at (Field2) — datetime(6)
- update_at (Field3) — datetime(6)
- is_deleted (Field4) — boolean
mission_list (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
- 내용 (Field) — text
- created_at (Field2) — datetimne(6)
- updated_at (Field3) — datetime(6)
- point (Field4) — int
- is_deleted (Field5) — boolean
review (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- mission_id (Key2) — bigint — Foreign key → member_mission.id — NOT NULL
- member_id (Key22) — bigint — Foreign key → member_mission.member_id — NOT NULL
- member_mission_id (Key222) — bigint — Foreign key → member_mission.mission_id — NOT NULL
- memo (Field) — text
- score (Field4) — int
- created_at (Field2) — datetime(6)
- update_at (Field3) — datetime(6)
- is_deleted (Field5) — boolean
store (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- adress (Field2) — varchar(20)
- information (Field3) — text
- created_at (Field4) — datetime(6)
- update_at (Field5) — datetime(6)
- is_deleted (Field6) — boolean