NYAM

Tables (5)

Board (식단)

  • id — INT — Primary key — NOT NULL
  • food_name — VARCHAR(10)
  • calorie — INT
  • carbs — INT
  • protein — INT
  • reg_date — TIMESTAMP

Disease (질병)

  • disease_id — INT — Primary key — NOT NULL
  • disease_name — VARCHAR(30)

Foods (음식)

  • food_id — INT — Primary key — NOT NULL
  • food_name — VARCHAR(10)
  • calorie — INT
  • carbs — INT
  • protein — INT

User (회원)

  • userid — INT — Primary key — NOT NULL
  • pw — VARCHAR(20)
  • name — VARCHAR(20)
  • age — INT
  • height — INT
  • weight — INT
  • abled — BOOLEAN

User_disease (회원의 질병)

  • userid — INT — Foreign key → User.userid — NOT NULL
  • disease_id — INT — Foreign key → Disease.disease_id — NOT NULL