ddAPI

Tables (5)

DiabetesDiary (혈당 일지)

  • diary_id (일지 식별자) — BIGINT — Primary key — NOT NULL
  • writer_id (작성자 식별자) — BIGINT — Foreign key → Writer.writer_id — NOT NULL
  • fpg (공복 혈당) — INTEGER
  • remark (비고) — VARCHAR
  • written_time (작성 시간) — DATETIME

Diet (식단)

  • diet_id (식단 식별자) — BIGINT — Primary key — NOT NULL
  • diary_id (일지 식별자) — BIGINT — Foreign key → DiabetesDiary.diary_id — NOT NULL
  • writer_id (작성자 식별자) — BIGINT — Foreign key → DiabetesDiary.writer_id — NOT NULL
  • blood_sugar (식사 혈당) — INTEGER
  • eat_time (식사 시간) — VARCHAR

Food (음식)

  • food_id (음식 식별자) — BIGINT — Primary key — NOT NULL
  • diet_id (식단 식별자) — BIGINT — Foreign key → Diet.diet_id — NOT NULL
  • diary_id (일지 식별자) — BIGINT — Foreign key → Diet.diary_id — NOT NULL
  • writer_id (작성자 식별자) — BIGINT — Foreign key → Diet.writer_id — NOT NULL
  • food_name (음식 이름) — VARCHAR
  • amount (음식 수량) — DOUBLE
  • amount_unit (수량 단위) — VARCHAR

Profile (작성자 프로필)

  • profile_id (프로필 식별자) — BIGINT — Primary key — NOT NULL
  • diabetes_phase (당뇨 단계) — VARCHAR

Writer (작성자)

  • writer_id (작성자 식별자) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • email (이메일) — VARCHAR
  • password (비밀번호) — VARCHAR
  • role (인가 권한) — VARCHAR
  • provider (OAauth 제공 회사) — VARCHAR
  • provider_id (OAuth 제공 회사 식별자) — VARCHAR
  • profile_id (프로필 식별자) — BIGINT — Foreign key → Profile.profile_id — NOT NULL