CureMore

Tables (7)

ALRAM (ALARM)

  • PK (member_id) — varchar2(20) — Foreign key → PRESC_INFO.PK — NOT NULL
  • NN (yak_name) — varchar2(20)
  • (time_a) — varchar2(20)
  • (time_b) — varchar2(20)

DISEASE_INFO

  • PK (disease_code) — varchar2(10) — Foreign key → PRESC_INFO.FK — NOT NULL
  • NN (disease_name) — varchar2(10)
  • (disease_explanation) — varchar2(500)

IMGUP

  • PK (filename) — varchar2(20)
  • NN (filepath) — varchar2(20)
  • NN (member_id) — varchar2(20)

MEDI_TERM

  • PK (Medi_Term_Name) — varchar2(100) — Foreign key → DISEASE_INFO.PK — NOT NULL
  • NN (Medi_Term_Info) — varchar2(3000)

MEMBER

  • PK (member_id) — varchar2(20) — Primary key — NOT NULL
  • NN (member_pw) — varchar2(20)
  • NN (member_name) — varchar2(20)
  • NN (member_age) — number
  • NN (member_tel) — varchar2(20)

PRESC_INFO

  • FK (disease_code) — varchar2(10) — Primary key — NOT NULL
  • PK (member_id) — varchar2(20) — Foreign key → MEMBER.PK — NOT NULL
  • (yak_name) — varchar2(20)
  • (dose_vol) — varchar2(10)
  • (dose_freq) — number
  • (dose_period) — varchar2(100)
  • (dose_time) — varchar2(50)

YAK_INFO

  • FK (Medi_Term_Name) — varchar2(100) — Primary key — NOT NULL
  • PK (yak_name) — varchar2(100) — Foreign key → PRESC_INFO.PK — NOT NULL
  • NN (yak_effect) — varchar2(200)
  • NN (yak_dosage) — varchar2(3000)