CloneCoding
Tables (8)
Untitled (order)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (menu_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (result_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (amount) — INT
- Field (option_id) — INT
- Field (status) — VARCHAR
- Field (date_order)
Untitled (user)
- Key (id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(20)
- Field (phone) — VARCHAR(20)
- Field (password) — VARCHAR(100)
- Field (email) — VARCHAR(100)
- Field (address) — VARCHAR(100)
- Field (date_create) — DATETIME
- Field (date_edit) — DATETIME
Untitled (order_result)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (date_order) — VARCHAR
- Field (status) — VARCHAR
- Field (total_cost) — INT
Untitled (menu)
- Key (id) — INT — Primary key — NOT NULL
- Key (store_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255)
- Field (price) — INT
- Field (profile) — VARCHAR(255)
- Field (count) — INT
- Field (date_order) — DATETIME
Untitled (option)
- Key (id) — INT — Primary key — NOT NULL
- Key (menu_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR
- Field (price) — INT
- Field (belonging_item) — INT
Untitled (store)
- Key (id) — INT — Primary key — NOT NULL
- Field (state)
- Field (title)
- Field2 (size)
- Field3 (sort)
- Field (address_land)
- Field (address_road)
- Field4 (post)
- Field (latitude) — LONG
- Field (longitude) — LONG
- Field (minimum_price) — INT
- Field (payment_option)
- Field (info)
- Field (hours)
Untitled (review)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (store_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (star) — INT
- Field (content) — VARCHAR(1000)
- Field (date_post) — DATETIME
Untitled (category)
- Key (id) — INT — Primary key — NOT NULL
- Field (title) — VARCHAR
- Field (name) — VARCHAR
- Field (image) — VARCHAR
- Field (file) — VARCHAR