db_pj erd

Tables (7)

CITIZEN (Untitled3)

  • citizenID (Key) — varchar(7) — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • phone (Field3) — varchar(20)
  • adrressID (Key2) — int — Foreign key → address.adrressID — NOT NULL

CORONIC (Untitled4)

  • index (Key) — int(auto) — Primary key — NOT NULL
  • citizenID (Key2) — varchar(7) — Foreign key → CITIZEN.citizenID — NOT NULL
  • testDate (Field) — date
  • recovery (Field2) — varchar(5)

FACILITY (Untitled)

  • facilityID (Key) — int(auto) — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • phone (Field2) — varchar(20)
  • seat (Field4) — int
  • adrressID (Key2) — int — Foreign key → address.adrressID — NOT NULL

PREFERENCE (Untitled9)

  • prefID (Key) — int(auto) — Primary key — NOT NULL
  • facilityID (Key2) — int(auto) — Foreign key → TAG.facilityID — NOT NULL
  • preference (Field) — varchar(10)

QR code (Untitled2)

  • qrIndex (Key) — int(auto) — Primary key — NOT NULL
  • citizenID (Key3) — varchar(7) — Foreign key → CITIZEN.citizenID — NOT NULL
  • facilityID (Key2) — int(auto) — Foreign key → FACILITY.facilityID — NOT NULL
  • date (Field) — datetime

TAG (Untitled7)

  • facilityID (Key) — int(auto) — Foreign key → FACILITY.facilityID — NOT NULL
  • kind (Field) — varchar(10)
  • price (Field2) — varchar(10)

address (Untitled6)

  • adrressID (Key) — int(auto) — Primary key — NOT NULL
  • city (Field) — varchar(10)
  • district (Field2) — varchar(10)
  • dong (Field3) — varchar(10)