eland
Tables (4)
basket
- no — int(6) — Primary key — NOT NULL
- mid — char(30) — NOT NULL
- pcode — varchar(6) — NOT NULL
- pea — int(2) — NOT NULL
- pindate — timestamp — NOT NULL
member
- no — int(8) — Primary key — NOT NULL
- mid — char(30) — NOT NULL
- mname — char(50) — NOT NULL
- mpass — varchar(30) — NOT NULL
- mage — int(2) — NOT NULL
- mhp — char(11) — NOT NULL
- memail — varchar(50) — NOT NULL
- mtel — char(13) — NOT NULL
- mpost — char(5) — NOT NULL
- maddr — varchar(200) — NOT NULL
- maddr_dtc — varchar(100) — NOT NULL
pay
- no — int — Primary key — NOT NULL
- mid — char(30) — NOT NULL
- mname — char(50) — NOT NULL
- pcode — varchar(6) — NOT NULL
- ea — int(2) — NOT NULL
- money — int(8) — NOT NULL
- paydate — date — NOT NULL
product
- no — int(8) — Primary key — NOT NULL
- pcode — int(6) — NOT NULL
- pnm — varchar(200) — NOT NULL
- pmoney — int(8) — NOT NULL
- psales — varchar(7)
- psales_use — enum('Y','N') — NOT NULL
- pdiscount — varchar(5)
- pea — int(4) — NOT NULL
- pdate — timestamp — NOT NULL