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