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)