yogiyo-clone
Tables (6)
Shop
- Key (id) — long — Primary key — NOT NULL
- Key (owner_id) — long — Foreign key → Untitled.Key — NOT NULL
- Field (name) — String
- Key3 (latitude) — double — NOT NULL
- Key2 (longitude) — double — NOT NULL
- Field (order_num) — int
- Field (review_num) — int
- Field (total_score) — double
- Field (min_order_price) — int
- Field2 (min_delivery_price) — int
Untitled (Owner)
- Key (id) — long — Primary key — NOT NULL
- Field (name) — String
Untitled (category_shop)
- Key (id) — long — Primary key — NOT NULL
- Key (category_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (shop_id) — long — Foreign key → Shop.Key — NOT NULL
Untitled (category)
- Key (id) — long — Primary key — NOT NULL
- Field (name) — String
Untitled (order)
- Key (id) — long — Primary key — NOT NULL
- Key (owner_id) — long — Foreign key → Shop.Key — NOT NULL
- Field (created_at) — date
- Field (address) — String
- Field (status) — String
Untitled (review)
- Key (id) — long — Primary key — NOT NULL
- Key (owner_id) — long — Foreign key → Shop.Key — NOT NULL
- Field (created_at) — date
- Field (contents) — String