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