ERD

Tables (5)

Copy Of Untitled (강사)

  • Key (강사코드) — PK — Primary key — NOT NULL
  • Field (이름)
  • Field (이메일)
  • Field (전화번호)

Copy Of Untitled2 (과목)

  • Key (과목설명) — Primary key — NOT NULL
  • Field (강사코드)
  • Field (과목카테고리)
  • Field (개강일)
  • Field (강의료)

Copy Of Untitled3 (날짜별 회원 섭취 칼로리)

  • Key (날짜) — PK — Primary key — NOT NULL
  • Key (회원ID) — PK — Primary key — NOT NULL
  • Key (음식번호) — FK — Primary key — NOT NULL
  • Field (나이)
  • Field (키)
  • Field (몸무게)
  • Field

Untitled (온라인 강의)

  • Key (과목명) — PK — Primary key — NOT NULL
  • Field (강사코드) — FK

Untitled (회원)

  • Key (회원ID) — PK — Primary key — NOT NULL
  • Field (회원명)
  • Field (나이)
  • Field (키)
  • Field (몸무게)