SM2_Demo_Hotel
Tables (4)
Demo_Hotel_Hotels_List
- brandCode (Key) — Primary key — NOT NULL
- brand
- Field3
- Field4
- Field5
Demo_Hotel_Member (Untitled3)
- memNo (Key) — number — Primary key — NOT NULL
- email (Field) — text
- gender (Field2) — text
- ageband (Field3) — text
- addr (Field4) — number
- joinDate (Field5) — date
- joinChannel (Field6) — text
- membership (Field7) — text
- emailConsent (Field8) — text
- smsConsent (Field9) — text
- privacyConsent (Field10) — text
- preferHotel (Field11) — text
- yearlyCharge (Field12) — number
Demo_Hotel_Room_TR (Untitled)
- orderNo (Key) — number — Primary key — NOT NULL
- memNo (Key2) — number — Foreign key → Demo_Hotel_Member.memNo — NOT NULL
- itemNo (Key3) — number — Foreign key → Demo_Hotel_Room_TR_Detail.itemNo — NOT NULL
- brandCode (Key22) — text — Foreign key → Demo_Hotel_Room_TR_Detail.brandCode — NOT NULL
- memNo (Field) — number
- orderDate (Field2) — date
Demo_Hotel_Room_TR_Detail (Untitled2)
- itemNo (Key) — number — Primary key — NOT NULL
- brandCode (Key2) — text — Foreign key → Demo_Hotel_Hotels_List.brandCode — NOT NULL
- orderNo (Field) — number
- brandCode — number
- cpCode (Field3) — number
- cpnUse (Field4) — text
- qty (Field5) — number
- sales (Field6) — number
- discount (Field7) — number