Wanted
Tables (4)
Location (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- do-si (Field) — varchar(255)
- sgg (Field2) — varchar(255)
- lat (Field3) — varchar(255)
- lon (Field4) — varchar(255)
Member (Untitled)
- id — bigint — Primary key — NOT NULL
- email (Field) — varchar(255) — NOT NULL
- password (Field2) — varchar(255) — NOT NULL
- refresh_token (Field3) — varchar(255)
- username (Field4) — varchar(255)
Review (Untitled3)
- member_id (2) — bigint — Foreign key → Member.id — NOT NULL
- store_id (Key) — bigint — Foreign key → Store.id — NOT NULL
- score (Field) — int
- content (Field2) — varchar(255)
Store (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- lat (Field) — varchar(255)
- lon (Field2) — varchar(255)
- name (Field3) — varchar(255)
- address (Field4) — varchar(255)
- category (Field5) — varchar(255)
- rating (Field6) — double