markerskorea

Tables (5)

Location (Untitled2)

  • PrimaryKey (id) — Int — Primary key — NOT NULL
  • Field (name) — Varchar

Member (Untitled)

  • Primary Key (id) — Int — Primary key — NOT NULL
  • Field (email) — Varchar
  • Field2 (password) — Varchar
  • Field3 (membershipGrade) — Varchar
  • Field4 (name) — Varchar
  • Field5 (address) — Varchar

Price (Untitled3)

  • PrimaryKey (id) — Int — Primary key — NOT NULL
  • Field (membershipGrade) — Varchar
  • Field (deviceType) — Varchar
  • Field2 (price) — Int

RF (Untitled4)

  • PrimaryKey (id) — Int — Foreign key → Location.PrimaryKey — NOT NULL
  • Field (uniqueId) — Varchar
  • Field2 (address) — Varchar
  • Field3 (installationDate) — DateTime
  • Field4 (locationId) — Int

RFID (Untitled5)

  • PrimaryKey (id) — Int — Foreign key → Location.PrimaryKey — NOT NULL
  • Field (uniqueId) — Varchar
  • Field2 (address) — Varchar
  • Field3 (installationDate) — DateTime
  • Field4 (locationId) — Int