관리하당
테이블 (10)
BloodRecord
- Record_num — VARCHAR2(20) — 기본 키 — NOT NULL
- Record_level — NUMBER(5)
- Record_content — VARCHAR2(200)
- Record_time — DATETIME
- User_id (User_id2) — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Care
- Care_num — INT(10) — 기본 키 — NOT NULL
- Care_category — VARCHAR2(10)
- Care_title — VARCHAR2(20)
- Care_time — TIMESTAMP
- Com_readcount — NUMBER(11)
- Care_thumbnail — BLOB
- Care_content — VARCHAR2(300)
- Care_filename — VARCHAR2(30)
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Checklist
- Checklist_num — NUMBER(20) — 기본 키 — NOT NULL
- Checklist_content — VARCHAR2(100)
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Community
- Com_num — INT(10) — 기본 키 — NOT NULL
- Com_category — VARCHAR2(10)
- Com_title — VARCHAR2(20)
- Com_time — TIMESTAMP
- Com_readcount — NUMBER(11)
- Com_content — VARCHAR2(300)
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Exercise
- Ex_num — INT(20) — 기본 키 — NOT NULL
- Ex_category — VARCHAR2(20)
- Ex_title — VARCHAR2(30)
- Ex_time — DATETIME
- Ex_readcount — INT(11)
- Ex_content — VARCHAR2(200)
- Ex_image — VARCHAR2(20)
- Ex_filename — VARCHAR2(30)
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Medi_Regist
- Medi_name — VARCHAR2(20) — 기본 키 — NOT NULL
- Medi_period — VARCHAR2(20)
- Medi_end — VARCHAR2(20)
- Medi-inject — INT(10)
- Medi_time — DATETIME
- Medi_content — VARCHAR2(100)
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Medi_Search
- Medi_Search_name — VARCHAR2(20) — 기본 키 — NOT NULL
- Medi_info — VARCHAR2(100)
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Recommend
- Rec_foodnum — NUMBER(20) — 기본 키 — NOT NULL
- Rec_food — VARCHAR2(50)
- Dic_foodname — VARCHAR2(20)
- Dic_info_cal — VARCHAR2(20)
- Checklist_num — NUMBER(20) — 외래 키 → Checklist.Checklist_num — NOT NULL
- User_id — VARCHAR2(20) — 외래 키 → User.User_id — NOT NULL
Report
- Re_num — INT(10) — 기본 키 — NOT NULL
- Re_avg — VARCHAR2(50)
- Re_cal — VARCHAR2(50)
- Re_medi — VARCHAR2(50)
- Record_num — VARCHAR2(20) — 외래 키 → BloodRecord.Record_num — NOT NULL
- Medi_name — VARCHAR2(20) — 외래 키 → Medi_Regist.Medi_name — NOT NULL
- Rec_foodnum — NUMBER(20) — 외래 키 → Recommend.Rec_foodnum — NOT NULL
- Ex_num — INT(20) — 외래 키 → Exercise.Ex_num — NOT NULL
User
- User_id — VARCHAR2(20) — 기본 키 — NOT NULL
- User_pw — VARCHAR2(20)
- User_pw_q — VARCHAR2(50)
- User_pw_a — VARCHAR2(50)
- User_nick — VARCHAR2(10)
- User_number — VARCHAR2(8)
- User_name — VARCHAR2(10)
- User_gender — CHAR(5)
- User_phone — VARCHAR2(20)
- User_address — VARCHAR2(30)
- User_email — VARCHAR2(20)
- User_birth — DATETIME
- User_auth — INT(10)