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