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