share kitchen

Tables (3)

USER (Untitled)

  • userID (Key) — Primary key — NOT NULL
  • userpasword (Field)
  • username (Field2)
  • userphonenumber (Field3)
  • userRoadaddress (Field4)
  • userSpecificaddress (Field5)
  • userpostmi,ber (Field6)
  • usertype (Field7)

bbs (Untitled2)

  • bbsID (Key) — Primary key — NOT NULL
  • userID (Key2) — Foreign key → USER.userID — NOT NULL
  • name (Field)
  • phonenumber (Field2)
  • postnumber (Field3)
  • roadaddress (Field4)
  • title (Field5)
  • storedate (Field6)
  • storeshape (Field7)
  • storearea (Field8)
  • storeseat (Field9)
  • storedeposits (Field10)
  • troemonthrent (Field11)
  • storestarttume (Field12)
  • storeendtime (Field13)
  • storepotion1 (Field14)
  • storepotion2 (Field15)
  • storepotion3 (Field16)
  • storepotion4 (Field17)
  • storenearschool (Field18)
  • storenearstation (Field19)
  • storenearage (Field20)
  • bbsDate (Field21)
  • storeexplain (Field22)
  • bbsavilable (Field23)

contract (Untitled3)

  • contractID (Key) — Primary key — NOT NULL
  • userID (Key2) — Foreign key → USER.userID — NOT NULL
  • rentaddress (Field)
  • rentssn (Field2)
  • rentphonenumber (Field3)
  • rentname (Field4)
  • hireaddress (Field5)
  • hiressn (Field6)
  • hirephonnumber (Field7)
  • hirename (Field8)
  • contractdate (Field9)
  • userID (Field10)