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)