wine

Tables (6)

Product

  • Key (pno) — number(5) — Primary key — NOT NULL
  • Field (pname) — varchar(50)
  • Field (salprice) — number(10)
  • Field (price) — number(10)
  • Field (pinfo) — varchar(100)
  • Field (sugar) — number(2)
  • Field (kind) — varchar2(15)
  • Field2 (place) — varchar2(30)
  • Field (pbottle) — number(5)
  • Field (pdate) — date

Untitled (Order)

  • Key (odno) — number(5) — Primary key — NOT NULL
  • uid — varchar2(20) — Foreign key → User.uid — NOT NULL
  • Key (pno) — number(5) — Foreign key → Product.Key — NOT NULL
  • Field (obottle) — number(5)
  • Field (odate) — date

Untitled (Admin)

  • Key (aid) — varchar2(20) — Primary key — NOT NULL
  • Field (apw) — varchar2(20)
  • Field (aname) — varchar2(20)
  • Field (atel) — varchar2(15)

Untitled (Product manage)

  • Key (pno) — number(5) — Foreign key → Product.Key — NOT NULL
  • Key (aid) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (bottle) — number(5)

Untitled (Theme)

  • Key (tname) — varchar2(20) — Primary key — NOT NULL
  • Key (pno) — number(5) — Foreign key → Product.Key — NOT NULL

User

  • uid — varchar2(20) — Primary key — NOT NULL
  • upw — varchar2(20)
  • uname — varchar2(20)
  • utel — varchar2(15)
  • birth — date
  • address — varchar2(20)
  • Field2 (date) — date