Fridge1
Tables (4)
Item (item)
- item id (iID) — varchar2(30) — Primary key — NOT NULL
- item name (itemname) — varchar2(30)
- itemprice — number(10)
- item expiration date (expdate) — varchar2(50)
- item company (itemcompany) — varchar2(30)
- item quantity (itemquantity) — number
Member (member)
- member id (memberid) — varchar2(15) — Primary key — NOT NULL
- member name (membername) — varchar2(20)
- sex (gender) — char(1)
- email — varchar2(30)
- phon number (phone) — char(11)
- register date (registerdate) — date
- unregister flag (unflag) — char(1)
- unregister date (unregisterdate) — date
- non-member flag (memflag) — char(1)
- password — varchar2(300)
Register Table (register)
- register number (registerno) — number — Primary key — NOT NULL
- member id (memberid) — varchar2(15) — Foreign key → Member.member id — NOT NULL
- total quantity (totalquantity) — number
- register date (regusterdate) — date
Register_Item (register item)
- register number (registerno) — number — Foreign key → Register Table.register number — NOT NULL
- item id (iID) — varchar2(30) — Foreign key → Item.item id — NOT NULL
- count — number