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