teamproject

Tables (8)

Chat (Untitled8)

  • Key — BIGINT — Primary key — NOT NULL
  • Key (Key2) — BIGINT — Foreign key → ChatRoom.Key — NOT NULL
  • Description — VARCHAR

ChatRoom (Untitled5)

  • Key — BIGINT — Primary key — NOT NULL
  • Key (User) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (Lessor) — BIGINT — Foreign key → Lessor.Key — NOT NULL
  • Title — VARCHAR

Lend (Untitled4)

  • Key — BIGINT — Primary key — NOT NULL
  • Key (Key2) — BIGINT — Foreign key → User.Key — NOT NULL
  • StartDateTime — DATETIME
  • EndDateTime — DATETIME
  • Price — INT
  • Status — VARCHAR

Lessor (Untitled3)

  • Key — BIGINT — Primary key — NOT NULL
  • Email — VARCHAR
  • Password — VARCHAR
  • BusinessNumber — VARCHAR
  • Point — INT
  • Role — VARCHAR

Office (Untitled2)

  • Key — BIGINT — Primary key — NOT NULL
  • Key (User) — BIGINT — Foreign key → Lend.Key — NOT NULL
  • Key (Lessor) — BIGINT — Foreign key → Lessor.Key — NOT NULL
  • Name — VARCHAR
  • Si (Region) — VARCHAR
  • Gu — VARCHAR
  • Gun — VARCHAR
  • Ri — VARCHAR
  • Address — VARCHAR
  • Streets — VARCHAR
  • LON — DOUBLE
  • LAT — DOUBLE
  • ZIP — INT
  • Building_Number — INT
  • Price — INT
  • PriceStandard — VARCHAR
  • Min_Capacity — INT
  • Max_Capacity — INT
  • Monday — VARCHAR
  • Tuesday — VARCHAR
  • Wednesday — VARCHAR
  • Thursday — VARCHAR
  • Friday — VARCHAR
  • Saturday — VARCHAR
  • Sunday — VARCHAR
  • AirConditioner — VARCHAR
  • Cafe — VARCHAR
  • Printer — VARCHAR
  • ParcelService — VARCHAR
  • Doorlock — VARCHAR
  • Powersocket — VARCHAR
  • FAX — VARCHAR
  • AlldayService (Alldayservice) — VARCHAR
  • NoHoliday — VARCHAR
  • Heater — VARCHAR
  • Parkinglot — VARCHAR
  • PublicLounge — VARCHAR
  • PublicKitchen — VARCHAR
  • Rooftop — VARCHAR
  • PrivateLocker — VARCHAR
  • BeamProjector — VARCHAR
  • WhiteBoard (Whiteboard) — VARCHAR
  • WIFI — VARCHAR
  • ShowerRoom — VARCHAR
  • Storage — VARCHAR

PointUsage (Untitled6)

  • Key — BIGINT — Primary key — NOT NULL
  • Key (Key2) — BIGINT — Foreign key → User.Key — NOT NULL
  • Charge — INT
  • UsedDateTime — DATETIME
  • Status — VARCHAR

Review (Untitled7)

  • Key2 — BIGINT — Primary key — NOT NULL
  • Key — BIGINT — Foreign key → User.Key — NOT NULL
  • StarRating — INT
  • Title — VARCHAR
  • Description — VARCHAR
  • Type — VARCHAR

User (Untitled)

  • Key — BIGINT — Primary key — NOT NULL
  • Name — VARCHAR
  • Email — VARCHAR
  • Password — VARCHAR
  • Point — BIGINT