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