room1t

Tables (8)

availability (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • spaceId (Field) — Long
  • date (Field2) — datetime
  • opentime (Field3) — datetime
  • closetime (Field4) — datetime
  • Field5

booking (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Field) — Long
  • spaceId (Field2) — Long
  • startTime (Field3) — datetime
  • endTime (Field4) — datetime
  • status (Field5) — boolean
  • bookedTime (Field6) — datetime
  • price (Field7) — int
  • status (Field8) — boolean
  • created (Field9) — datetime
  • update (Field10) — datetime
  • Field11

chatmessage (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • chatRoomId (Field) — Long
  • sendId (Field2) — Long
  • messageText (Field3) — String
  • isAdminMessage (Field4) — boolean
  • sendTime (Field5) — datetime
  • Field6

chatroom (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Field) — Long
  • adminId (Field2) — Long
  • status (Field3) — boolean
  • (Field4)

patment (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • bookingId (Field) — Long
  • userId (Field2) — Long
  • amount (Field3) — int
  • status (Field4) — String
  • paymentMethod (Field5) — String
  • created (Field6) — datetime
  • Field7

space (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • description (Field2) — String
  • address (Field5) — String
  • ownerId (Field6) — Long
  • Field7

spacedetail (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • spaceId (Field) — Long
  • name (Field2) — String
  • description (Field3) — String
  • capacity (Field4) — int
  • pricePerHour (Field5) — int
  • address (Field6) — String
  • ownerId (Field7) — Long
  • Field8

user (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • gender (Field2) — boolean
  • eamil (Field3) — String
  • loginId (Field4) — String
  • password (Field5) — String
  • isadmin (Field6) — boolean
  • Field7