ManYak

Tables (8)

User (user)

  • 회원ID (user_id) — int(100) — Primary key — NOT NULL
  • 비밀번호 (user_password) — Varchar(50)
  • 휴대폰번호 (user_phone) — varchar(11)
  • 이름 (user_name) — varchar(50)
  • 성별 (user_sex) — varchar(50)
  • 생년월일 (user_birth) — varchar(50)

alarm

  • 프로필ID (profile_id) — varchar(50) — Foreign key → profile.프로필ID — NOT NULL
  • alarm — timestamp
  • 스캔된 약ID (scanned_medicine) — varchar(50) — Foreign key → scanned_medicine.스캔된 약ID — NOT NULL

food

  • 음식ID (food_id) — int(100) — Primary key — NOT NULL
  • 이름 (food_name) — varchar(50)
  • 질병 (food_disease) — varchar(500)
  • 설명 (food_info) — varchar(500)

medicine

  • 약ID (medicine_id) — int(100) — Primary key — NOT NULL
  • 효능 (efcyQesitm) — varchar(500) — Primary key — NOT NULL
  • 식별 (itemName) — varchar(500)
  • 복약 (useMedthodQesitm) — varchar(500)
  • 주의 (atpnQesitm) — varchar(500)
  • 보관 (depositMethodQesitm) — varchar(500)
  • 약 이름 (entpName) — varchar(500) — Foreign key → scanned_medicine.약 이름 — NOT NULL

profile

  • 프로필ID (profile_id) — int(100) — Primary key — NOT NULL
  • 이름 (profile_name) — varchar(50)
  • 생년월일 (profile_birth) — varchar(50)
  • 핸드폰 번호 (profile_phone) — varchar(11)
  • 성별 (profile_sex) — varchar(11
  • 질병이력 (profile_disease) — varchar(100)
  • 회원ID (user_id2) — CHAR(4) — Foreign key → User.회원ID — NOT NULL

scanned_medicine

  • 스캔된 약ID (scanned_medicine) — int(100) — Primary key — NOT NULL
  • 약 이름 (entpName) — varchar(500) — Primary key — NOT NULL
  • 스캔 날짜 (scanned_date) — timestamp
  • 프로필ID (profile_id) — varchar(50) — Foreign key → profile.프로필ID — NOT NULL

supplements

  • 건기식ID (sup_id) — int(100) — Primary key — NOT NULL
  • 이름 (sup_name) — varchar(50)
  • 가격 (sup_price) — int(11)
  • 증상 (sup_effect) — varchar(500)
  • 정보 (sup_info) — varchar(500)
  • 약ID (medicine_id) — int(100) — Foreign key → medicine.약ID — NOT NULL
  • 효능 (efcyQesitm) — varchar(500) — Foreign key → medicine.효능 — NOT NULL

wastedrug

  • 폐의약품ID (wastedrug_id) — int(100) — Primary key — NOT NULL
  • 배출장소ID (place_id) — varchar(500)
  • 상세주소 (address) — varchar(500)
  • 연락처 (number) — int(11)