mim
Tables (6)
member (Untitled)
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- birthday (Field) — int
- created_at (create_at) — datetime(6)
- updated_at — datetime(6)
- email (status) — varchar(50)
- my_point (Field2) — int
- complet_mission (Field3) — int
member_mission (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- status (Field) — varchar(10)
- point (Field2) — int
mission (Untitled2)
- id — bigint — Primary key — NOT NULL
- mission_name (Field2) — varchar(20)
- point (Field) — int
- Field3
region (Untitled4)
- id — bigint — Primary key — NOT NULL
- name (Field) — bigint
- address (Field2) — varchar(40)
review (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (id) — bigint — Foreign key → member.id — NOT NULL
- store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
- starpoint (Field2) — float
store (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- region_id (id) — bigint — Foreign key → region.id — NOT NULL
- mission_id (id2) — bigint — Foreign key → mission.id — NOT NULL
- name (Field2) — varchar(30)
- address (Field) — varchar(40)
- Field3