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