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)