thkimshop
Tables (10)
Untitled (item)
- Key (item_id) — int — Primary key — NOT NULL
- Field (name)
- Field2 (price)
- Field (stock_quantity)
- Field (dtype)
Untitled (album)
- Key (album_id) — Primary key — NOT NULL
- Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (artist)
- Field (etc)
Untitled (movie)
- Key2 (movie_id) — Primary key — NOT NULL
- Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (director)
- Field (actor)
Untitled (book)
- Key (book_id) — Primary key — NOT NULL
- Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (author)
- Field (isbn)
Untitled (order)
- Key (oder_id) — int — Primary key — NOT NULL
- Key (delivery_id) — Foreign key → Untitled.Key — NOT NULL
- Field (status)
- Field2 (order_date)
- user_id — int — Foreign key → user.user_id — NOT NULL
Untitled (order_item)
- Key (order_item_id) — Primary key — NOT NULL
- Key (oder_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (price)
- Field2 (count)
Untitled (category)
- Key (category_id) — Primary key — NOT NULL
- Field (parent_id)
- Field (name)
Untitled (category_item)
- Key (category_id) — Foreign key → Untitled.Key — NOT NULL
- Key (item_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (delivery)
- Key (delivery_id) — Primary key — NOT NULL
- Field (status)
- Field2 (city)
- Field (street)
- Field (zipcode)
user (member)
- user_id (member_id) — int — Primary key — NOT NULL
- Field (name)
- Field2 (phone)
- Field3 (email)
- Field (city)
- Field2 (street)
- Field3 (zipcode)