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)