SpaceOrder

Tables (5)

Card (Untitled7)

  • id (Key) — Number — Primary key — NOT NULL
  • id — number — Foreign key → Room.id — NOT NULL
  • credential (Field) — String
  • siteId (Field2) — String
  • cardType (Field3) — String
  • cardId (Field4) — String
  • imageUrl (Field5) — String
  • accessLevels (Field6) — String
  • lastModifiedAt (Field7) — number
  • createdAt (Field8) — Date
  • lastUpdateed (Field9) — Date

Order (Untitled4)

  • id (Key) — number — Primary key — NOT NULL
  • id — Number — Foreign key → User.id — NOT NULL
  • id (id2) — number — Foreign key → Room.id — NOT NULL
  • id (Key2) — Number — Foreign key → reserve.id — NOT NULL
  • tid (Field) — String
  • paidPrice (Field2) — Number
  • createdAt (Field3) — Date
  • lastUpdated (Field4) — Date

Room (Untitled2)

  • id — number — Primary key — NOT NULL
  • name — String
  • roomStatus (Field) — roomStatus
  • priceDay (Field2) — number
  • priceMonth (Field3) — number
  • openTime (Field4) — number
  • closedTime (Field5) — number
  • foodServe (Field6) — String
  • decription (Field7) — String
  • Address (Field8) — String
  • latitude (Field9) — number
  • longtitude (Field10) — number
  • thumbnailUrl (Field11) — string
  • imageUrl (Field12) — string
  • createdAt (Field13) — date
  • lastUpdated (Field14) — Date

User (Untitled)

  • id — Number — Primary key — NOT NULL
  • IsActive (Field) — Boolean
  • role (Role)
  • email — String
  • name — String
  • password (Field2) — String
  • phoneNumber — String
  • requiredAgreement (Field3) — Date
  • agreementMarketing (Field4) — Date
  • createdAt (Field5) — Date
  • lastUpdated (Field6) — Date

reserve (Untitled3)

  • id (Key) — Number — Primary key — NOT NULL
  • id — Number — Foreign key → User.id — NOT NULL
  • id (id2) — number — Foreign key → Room.id — NOT NULL
  • Status (Field) — enum
  • startDate (Field2) — Date
  • endDate (Field3) — Date
  • refundReason (Field4) — String
  • createdAt (Field5) — Date
  • lastUpdated (Field6) — Date