online shop

Tables (11)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (saddress)

  • Key (id) — int — Primary key — NOT NULL
  • Field (alias) — varchar(50)
  • Field (addr) — varchar(100)
  • Key (id2) — varchar(50) — Foreign key → Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (segment)

  • Key (code) — char(3) — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field (offer) — varchar(100)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (review)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — varchar(100)
  • Field (content) — varchar(500)
  • Key (id2) — int — Foreign key → Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (vendor)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(50)
  • Field (phone) — varchar(13)

Copy Of Copy Of Copy Of Copy Of Untitled (card)

  • Key (id) — int — Primary key — NOT NULL
  • Field (number) — char(16)
  • Field (provider) — varchar(50)
  • Field (exp_date) — char(4)
  • Key (id2) — varchar(50) — Foreign key → Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled (category)

  • Key (category_id) — int — Primary key — NOT NULL
  • Field (cname) — varchar(50)
  • Field2 (code) — char(3)

Copy Of Copy Of Untitled (shipping)

  • Key — Primary key — NOT NULL
  • Field

Copy Of Untitled (product)

  • Key (code) — char(10) — Primary key — NOT NULL
  • Field (title) — varchar(50)
  • Field (price) — int
  • Field (desc) — varchar(200)
  • Key (category_id) — int — Foreign key → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (id2) — int — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL

Untitled (member)

  • Key (id) — varchar(50) — Primary key — NOT NULL
  • Field (password) — varchar(50)
  • Field (name) — varchar(50)
  • Field (mobile) — char(13)
  • Field (addr) — varchar(50)
  • Key (code) — char(3) — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL

Untitled (order)

  • Key (id) — int — Primary key — NOT NULL
  • Field (date) — DateTime
  • Field (count) — int
  • Field (price) — int
  • Field (amount) — int
  • Key (id2) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Key (code) — char(10) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (id3) — int — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (mname) — varchar(50)
  • Field (pname) — varchar(50)

Untitled (cartitem)

  • Key (id) — int — Primary key — NOT NULL
  • Key (code) — char(10) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (id2) — varchar(50) — Foreign key → Untitled.Key — NOT NULL