관리하당

테이블 (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)