corona

Tables (3)

MEMBER (Member)

  • IDX (idx) — sequence — Primary key — NOT NULL
  • NAME (name) — VARCHAR2(10)
  • USERID (userid) — VARCGHAR2(30)
  • PWD (pwd) — VARCHAR2(30)
  • PHONE (phone) — VARCHAR2(30)
  • ADDR (addr) — VARCHAR2(50)
  • GENDER (gender) — NUMBER
  • SSN (ssn) — VARCHAR2(30)

VACCINE (vaccine)

  • VIDX (vidx) — sequence — Primary key — NOT NULL
  • IDX (idx2) — sequence — Foreign key → MEMBER.IDX — NOT NULL
  • VKIND (vkind) — VARCHAR2
  • V1 (v1) — CHAR(1) CHECK
  • V2 (v2) — CHAR(1) CHECK
  • V3 (v3) — CHAR(1) CHECK
  • LASTDATE (lastdate) — VARCHAR2

VRESERVATION (vreservation)

  • RIDX (ridx) — SEQUENCE — Primary key — NOT NULL
  • IDX (idx2) — sequence — Foreign key → MEMBER.IDX — NOT NULL
  • RDATE (rdate) — VARCHAR2
  • RHTP — VARCHAR2
  • RTIME (rtime) — timestamp