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