d
Tables (8)
CustomerLevel
- Key — VARCHAR(25) — Primary key — NOT NULL
- Field — VARCHAR(25)
- Field2 — VARCHAR(25)
Customers
- CustomerId — VARCHAR(25) — Primary key — NOT NULL
- CustomerName — VARCHAR(25)
- CustomerTel — VARCHAR(25)
- CustomerEmail — VARCHAR(25)
Engineer
- EngineerId — VARCHAR(25) — Primary key — NOT NULL
- EngineerName — VARCHAR(25)
- EngineerTel — VARCHAR(25)
Payment
- Key — VARCHAR(25) — Primary key — NOT NULL
- Field — VARCHAR(25)
a
- bicycleStandId — VARCHAR(25) — Primary key — NOT NULL
- Field1 — DATE
- Field4 — VARCHAR(25)
- Field — VARCHAR(25)
- Field5 — INT
- Field2 — INT
bicycle
- bicycleId — VARCHAR(25) — Primary key — NOT NULL
- bicycleName — VARCHAR(25)
- bicycleInfo — VARCHAR(25)
- bicyclePrice — INT
- bicycleReg — DATE
bicycleRent
- bicycleRentId — VARCHAR(25) — Primary key — NOT NULL
- bicycleRentPrice — VARCHAR(25)
- bicycleRentDate — VARCHAR(25)
- bicycleRentPlace — VARCHAR(25)
- biyclesReturnDate — VARCHAR(25)
- bicycledRentDate — VARCHAR(25)
- bicycledStorageTime — VARCHAR(25)
bicycleRepair
- Key — VARCHAR(25) — Primary key — NOT NULL
- Field — DATE
- Field2 — INT
- Field3 — BOOLEAN
- Field4 — DATE