PrimaryProj
Tables (3)
MEMBER
- MID — VARCHAR2(40) — Primary key — NOT NULL
- PWD — VARCHAR2(40)
- NAME — VARCHAR2(40)
- GENDER — VARCHAR2(40)
- BIRTHDAY — DATE
- AGE — NUMBER
- PHONE — VARCHAR2(40)
- ADDRESS — VARCHAR2(40)
NOTICE
- SEQ — NUMBER — Primary key — NOT NULL
- WRITER — VARCHAR2(40) — Foreign key → MEMBER.MID — NOT NULL
- TITLE — VARCHAR2(30) — NOT NULL
- CONTENT — VARCHAR2(2000) — NOT NULL
- REGDATE — DATE — NOT NULL
PHARMACY
- PHARMACYNAME — VARCHAR2(30) — Primary key — NOT NULL
- PADDR — VARCHAR(2000) — NOT NULL
- CALLNUM — VARCHAR2(20)
- OPTIME — VARCHAR2(20) — NOT NULL
- NOTE — VARCHAR2(20)