μ 리λ₯Ό ν΄λ³΄μ
λμκ΄μλ κ° μκ³ /μκ°μ λ§μ μ± λ€μ΄ μλ€.
--> λμκ΄ , μκ³ /μκ° , μ±
κ³ κ°λ€μ μΈν°λ·μ ν΅ν΄μ λ‘κ·ΈμΈν ν λμ λͺ©λ‘μ μ‘°νν μ μλ€.
--> κ³ κ° , λ‘κ·ΈμΈνλ€ , λμ λͺ©λ‘ , μ‘°ννλ€
κ³ κ°λ€μ μνλ μ± μ λμΆ λ°μ μ μλ€.
--> κ³ κ° , μ± , λμΆλ°λ€
κ³ κ°μ μ± μ΄ μμ κ²½μ° λμΆ μμ½μ ν μ μμΌλ©° , λμΆμ μν΄μλ μ§μ λ°©λ¬Έν΄μ μ± μ μ°Ύμμ λμΆμ ν΄μΌ νλ€.
--> κ³ κ° , μ± , λμΆμμ½νλ€
μκ³
@Entity
public class Library {
@Id @GeneratedValue
@Column(name = "library_id")
private Long id;
@Column(name = "library_name")
private String name;
}
μκ°
@Entity
public class Shelf {
@Id @GeneratedValue
@Column(name = "shelf_id")
private Long id;
@Column(name = "shelf_name")
private String name;
@ManyToOne
@JoinColumn(name = "library_id")
private Library library;
}
μ±
@Entity
public class Book {
@Id @GeneratedValue
@Column(name = "book_id")
private Long id;
@Column(name = "book_name")
private String name;
@ManyToOne
@JoinColumn(name = "library_id")
private Library library;
@ManyToOne
@JoinColumn(name = "shelf_id")
private Shelf shelf;
}
κ³ κ°
@Entity
public class Member {
@Id @GeneratedValue
@Column(name = "member_id")
private Long id;
@Column(name = "member_name")
private String name;
}
μ± λμΆ
@Entity
public class BookCheck {
@Id @GeneratedValue
@Column(name = "book_check_id")
private Long id;
@Column(name = "book_check_name")
private String name;
@ManyToOne
@JoinColumn(name = "member_id")
private Member member;
@Column(name = "check_date")
private Date date;
}
'Develop > DB' μΉ΄ν κ³ λ¦¬μ λ€λ₯Έ κΈ
[RDBMS Modeling κΈ°μ΄] 6. κ΄κ³(Relation) - μ°μ΅λ¬Έμ 1 (0) | 2023.03.08 |
---|---|
[MySQL] Mac OSμμ μ€μΉ λ° μ¬μ©λ°©λ² (homebrew μ΄μ©) (0) | 2023.03.06 |
[RDBMS Modeling κΈ°μ΄] 4. κ΄κ³(Relation) - M:N κ΄κ³ (0) | 2023.02.28 |
[RDBMS Modeling κΈ°μ΄] 3. κ΄κ³(Relation) - 1:M κ΄κ³ (0) | 2023.02.27 |
[RDBMS Modeling κΈ°μ΄] 2. Primary Key μ€κ³ (0) | 2023.02.26 |