jpa_study

Tables (6)

Food (Untitled6)

  • foodId (Key) — long — Primary key — NOT NULL
  • foodCategoryId (Key2) — long — Foreign key → FoodCategory.foodCategoryId — NOT NULL
  • RestrauntId (Key22) — long — Foreign key → FoodCategory.RestrauntId — NOT NULL
  • memberId (Key222) — Long — Foreign key → FoodCategory.memberId — NOT NULL
  • foodName (Field) — String
  • foodPrice (Field2) — String

FoodCategory (Untitled5)

  • foodCategoryId (Key) — long — Primary key — NOT NULL
  • RestrauntId (Key2) — long — Foreign key → Restraunts.RestrauntId — NOT NULL
  • memberId (Key22) — Long — Foreign key → Restraunts.memberId — NOT NULL
  • foodType (Field2) — Enum

Lecture (Untitled2)

  • lectureId (Key) — Long — Primary key — NOT NULL
  • lectureName (Field) — String
  • ProfName (Field2) — String
  • lectureTime (Field3) — dateTime
  • lectureClass (Field4) — Enum
  • memberId (Field5) — Long

Member (Untitled)

  • memberId (Key) — Long — Primary key — NOT NULL
  • memberName (Field) — String

Restraunts (Untitled4)

  • RestrauntId (Key) — long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
  • Restraunt (Field) — Restraunt

Score (Untitled3)

  • ScoreId (Key) — long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → Member.memberId — NOT NULL
  • lectureId (Key3) — Long — Foreign key → Lecture.lectureId — NOT NULL
  • lectureSemester (Field2) — String
  • ScoreString (Field3) — List