banchan
Tables (9)
Cart Table (Untitled)
- item_hash (Key) — Text — Primary key — NOT NULL
- check_state (Field) — Boolean
- price (Field2) — Int
- count (Field3) — Int
- title (Field4) — Text
- image_url (Field5) — Text
Cart Table (CopyOfUntitled3)
- item_hash (Key2) — Text — Foreign key → Item Table.item_hash — NOT NULL
- check_state (Field) — Boolean
- count (Field3) — Int
Item Table (Untitled3)
- item_hash (Key) — Text — Primary key — NOT NULL
- price (Field) — Int
- title (Field2) — Text
- image_url (Field3) — Text
- state (Field4) — Int
Order Table (Untitled2)
- order_id (Key) — Int — Primary key — NOT NULL
- delivery_state (Field) — Boolean
- Order_time (Field2) — Date
Order Table (CopyOfUntitled22)
- order_id (Key) — Int — Primary key — NOT NULL
- delivery_state (Field) — Boolean
- Order_time (Field2) — Date
Ordered item Table (CopyOfUntitled2)
- item_hash (Key) — Text — Primary key — NOT NULL
- order_id (Key2) — Int — Primary key — NOT NULL
- price (Field2) — Int
- count (Field3) — Int
- title (Field4) — Text
- image_url (Field5) — Text
Ordered item Table (CopyOfCopyOfUntitled2)
- order_id (Key3) — Int — Foreign key → Order Table.order_id — NOT NULL
- item_hash (Key2) — Text — Foreign key → Item Table.item_hash — NOT NULL
- price (Field2) — Int
- count (Field3) — Int
Recently Viewing Products Table (CopyOfUntitled)
- item_hash (Key) — Text — Primary key — NOT NULL
- view_time (Field) — Date
- price (Field2) — Int
- origin price (Field3) — Int
- title (Field4) — Text
- image_url (Field5) — Text
Recently Viewing Products Table (CopyOfCopyOfUntitled)
- item_hash (Key2) — Text — Foreign key → Item Table.item_hash — NOT NULL
- view_time (Field) — Date