TicketPlatform

테이블 (8)

Comment(댓글) (Entity(name = "comment"))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "comment_id")
  • 댓글내용 (commentContents) — varchar(4000) — NOT NULL — @Column(length = 4000, nullable = false)
  • 댓글등록날짜 (commentCreateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 댓글수정날짜 (commentUpdateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 댓글작성맴버ID(PK) (member) — Member — 외래 키 → Member(회원).ID(PK) — NOT NULL — @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "member_id")
  • 게시글 (post) — Post — 외래 키 → Post(게시글).ID(PK) — NOT NULL — @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "post_id")

Member(회원) (member(@Entity(name = "orders")))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "member_id")
  • 아이디 (memberId) — varchar(30) — NOT NULL — @Column(nullable = false, length = 30, unique=true)
  • 패스워드 (password) — varchar(50) — NOT NULL — @Column(nullbale = false, length = 30)
  • 이름 (memberName) — varchar(10) — NOT NULL — @Column(nullbale = false, column = 10)
  • 이메일 (memberEmail) — varchar(50) — NOT NULL — @Column(nullable = false, length = 50, unique = true)
  • 주문내역 (orderList) — List<Order> — @OneToMany(mappedBy = "memberId")
  • 보유티켓 (ticketList) — List<Ticket> — @OneToMany(mappedBy = "ticket")
  • 게시글목록 (postList) — List<Post> — @OneToMany(mappedBy = "member", orphanRemoval = true)
  • 재학여부 (universityAttendance) — boolean — NOT NULL — @Column(nullbale = false)
  • 생성날짜 (memberCreateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 수정날짜 (memberUpdateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");

Order(주문) (orders(@Entity(name = "orders")))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "order_id")
  • 주문가격 (orderPrice) — int — NOT NULL — @Column(nullable = false)
  • 주문수량 (orderCount) — int — NOT NULL — @Column(nullable = false)
  • 주문티켓 (ticketList) — List<Ticket> — NOT NULL — @OneToMany(mappedBy = "ticket")
  • 주문상태 (orderStatus) — OrderStatus — NOT NULL — ORDER, CANCEL / @Enumerated(EnumType.STRING)
  • 주문요청날짜 (orderCreateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 주문수정날짜 (orderUpdateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 주문회원ID(FK) (member) — Member — 외래 키 → Member(회원).ID(PK) — NOT NULL — @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "member_id")

OrderStatus(주문정보) (enum)

  • 주문 (ORDER) — String — ORDER
  • 주문취소 (CANCEL) — String — CANCEL

Performance(공연) (@Entity(name = "performance"))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "performance_id")
  • 공연이름 (performancName) — varchar(100) — NOT NULL — @Column(nullable = false, length = 100, unique=true)
  • 공연설명 (performanceContents) — CLOB(string) — NOT NULL — @Lob @Column(nullable = false)
  • 공연가격 (performancePrice) — int — NOT NULL — @Column(nullable = false)
  • 공연티켓 수량 (performanceCount) — int — NOT NULL — @Column(nullable = false)
  • 공연좌석 (performanceSeat) — varchar(255) — @ElementCollection
  • 공연시작날짜 (performanceDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");

Post(게시글) (@Entity(name = "comment"))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "post_id")
  • 문의이름 (postSubject) — varchar(10) — NOT NULL — @Column(nullable = false, length = 10)
  • 문의내용 (postContents) — varchar(4000) — NOT NULL — @Column(length = 4000, nullable = false)
  • 문의등록날짜 (postCreateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 문의수정날짜 (postUpdateDate) — LocalDateTime — DateTimeFormatter inputFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  • 댓글 (commentList) — List<Comment> — NOT NULL — @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "post_id", nullable = false)
  • 조회수 (viewCount) — Long — NOT NULL
  • 게시글작성맴버ID(PK) (member) — Member — 외래 키 → Member(회원).ID(PK) — NOT NULL — @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "member_id")

Seat(좌석) (@Entity(name = "seat"))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "seat_id")
  • 좌석 (seat) — varchar(20) — NOT NULL — @Column(nullable = false, length = 20, unique = true)
  • 좌석예약여부 (isBooked) — Boolean — NOT NULL — @Column(nullable = false)
  • 공연ID(FK) (performance) — Performance — 외래 키 → Performance(공연).ID(PK) — NOT NULL — @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "performance_id")

Ticket(티켓) (@Entity(name = "ticket"))

  • ID(PK) (id) — Long — 기본 키 — NOT NULL — @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "ticket_id")
  • 티켓이름 (ticketName) — varchar(50) — NOT NULL — @Column(nullable = false, length = 50, unique=true)
  • 가격 (ticketPrice) — int — NOT NULL — @Column(nullable = false)
  • 티켓좌석 (ticketSeat) — varchar(50) — NOT NULL — @Column(nullable = false, length = 50, unique = true)
  • 주문ID(FK) (order) — Order — 외래 키 → Order(주문).ID(PK) — NOT NULL — @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "order_id")
  • 공연ID(FK) (performance) — Performance — 외래 키 → Performance(공연).ID(PK) — NOT NULL — @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "performance_id")
  • 티켓구매맴버ID(PK) (member) — Member — 외래 키 → Member(회원).ID(PK) — NOT NULL — @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "member_id")
  • 좌석ID(PK) (seat) — Seat — 외래 키 → Seat(좌석).ID(PK) — NOT NULL — @OneToOne(fetch=FetchType.LAZY) @JoinColumn(name = "seat_id", unique = true)