졸업프로젝트

테이블 (26)

Carts

  • CartID — INT
  • MemberID — VARCHAR(13) — NOT NULL
  • GoodsID — INT — NOT NULL
  • Quantity — INT — NOT NULL
  • UnitPrice — INT — NOT NULL
  • TotalPrice — INT — NOT NULL

CouponMaster

  • CouponTypeID — INT
  • CouponTypeName — VARCHAR(50) — NOT NULL
  • CouponDiscountRate — DECIMAL(5, 2) — NOT NULL
  • IssuableCount — INT — NOT NULL
  • StartDate — DATE — NOT NULL
  • ExpiryDate — DATE — NOT NULL
  • ApplicationCategory — ENUM('Goods', 'Ticket') — NOT NULL

Coupons

  • CouponID — INT
  • CouponTypeID — INT — NOT NULL
  • MemberID — VARCHAR(13) — NOT NULL
  • ReservationID — INT — NOT NULL

Exchanges

  • ExchangeID — INT
  • OrderID — INT — NOT NULL
  • ExchangeRequestDate — TIMESTAMP — NOT NULL
  • ExchangeCompletionDate — TIMESTAMP — NOT NULL
  • ExchangeReason — TEXT — NOT NULL
  • ExchangeStatus — ENUM('Pending', 'Completed') — NOT NULL
  • ExchangeGoodsID — INT — NOT NULL

Goods

  • GoodsID — INT
  • Category — VARCHAR(50) — NOT NULL
  • ProductName — VARCHAR(100) — NOT NULL
  • Description — TEXT — NOT NULL
  • Size — VARCHAR(50) — NOT NULL
  • Price — INT — NOT NULL
  • StockQuantity — INT — NOT NULL
  • IsSoldOut — BOOLEAN — NOT NULL

Inquiries

  • InquiryID — INT
  • Title — VARCHAR(100) — NOT NULL
  • Content — TEXT — NOT NULL
  • ReferenceID — INT — NOT NULL
  • MemberID — VARCHAR(13) — NOT NULL
  • CreatedDate — TIMESTAMP — NOT NULL
  • InquiryReply — TEXT — NOT NULL
  • IsReplyHandled — BOOLEAN — NOT NULL
  • BoardType — ENUM('Inquiry', 'Comment', 'Cheer') — NOT NULL

Matches

  • MatchID — INT
  • HomeTeamID — INT — NOT NULL
  • AwayTeamID — INT — NOT NULL
  • StadiumID — INT — NOT NULL
  • MatchDate — DATETIME — NOT NULL
  • MatchTime — TIME — NOT NULL
  • Referee — VARCHAR(50) — NOT NULL
  • BookingStartDate — DATETIME — NOT NULL
  • BookingEndDate — DATETIME — NOT NULL

MemberMemberships

  • MemberMembershipID — INT
  • MemberID — VARCHAR(13) — NOT NULL
  • MembershipID — VARCHAR(50) — NOT NULL
  • Status — ENUM('Active', 'Expired') — NOT NULL
  • PurchaseDate — TIMESTAMP — NOT NULL

Memberships

  • MembershipID — VARCHAR(50)
  • MembershipName — VARCHAR(50) — NOT NULL
  • Price — INT — NOT NULL
  • StartDate — TIMESTAMP — NOT NULL
  • EndDate — TIMESTAMP — NOT NULL
  • Notes — TEXT
  • SaleStartDate — DATETIME — NOT NULL
  • SaleEndDate — DATETIME — NOT NULL
  • DiscountAmount — INT — NOT NULL

Notices

  • NoticeID — INT
  • Title — VARCHAR(300) — NOT NULL
  • Content — TEXT — NOT NULL
  • AuthorID — VARCHAR(13) — NOT NULL
  • CreatedDate — TIMESTAMP — NOT NULL
  • ModifiedDate — TIMESTAMP — NOT NULL
  • Category — ENUM('Notice', 'Event') — NOT NULL

OrderDetails

  • OrderDetailID — INT
  • OrderID — INT — NOT NULL
  • GoodsID — INT — NOT NULL
  • Quantity — INT — NOT NULL
  • UnitPrice — INT — NOT NULL
  • TotalPaymentAmount — INT — NOT NULL
  • IsCanceled — BOOLEAN — NOT NULL
  • CancelDate — TIMESTAMP
  • IsRefunded — BOOLEAN — NOT NULL
  • IsExchanged — BOOLEAN — NOT NULL

Orders

  • OrderID — INT
  • MemberID — VARCHAR(13) — NOT NULL
  • OrderDate — TIMESTAMP — NOT NULL
  • IsCanceled — BOOLEAN — NOT NULL
  • CancelDate — TIMESTAMP
  • OrderStatus — ENUM('Pending', 'Completed') — NOT NULL
  • CouponID — INT
  • UsedPoints — INT
  • FinalPaymentAmount — INT — NOT NULL
  • ShippingStartDate — TIMESTAMP
  • ShippingEndDate — TIMESTAMP
  • ShippingStatus — ENUM('Pending', 'Completed')
  • RecipientName — VARCHAR(50) — NOT NULL
  • ShippingAddress — VARCHAR(255) — NOT NULL
  • ShippingRequest — VARCHAR(255)
  • PaymentMethodCode — VARCHAR(5) — NOT NULL

PaymentMethods

  • PaymentMethodCode — VARCHAR(5)
  • PaymentMethodName — VARCHAR(50) — NOT NULL

Players

  • PlayerID — INT
  • TeamID — INT — NOT NULL
  • PlayerName — VARCHAR(50) — NOT NULL
  • Position — VARCHAR(50) — NOT NULL
  • BackNumber — INT — NOT NULL
  • BirthDate — DATE — NOT NULL
  • Height — DECIMAL(5, 2) — NOT NULL
  • Weight — DECIMAL(5, 2) — NOT NULL
  • JoiningYear — YEAR — NOT NULL
  • BirthPlace — VARCHAR(50) — NOT NULL

PointHistory

  • PointHistoryID — INT
  • MemberID — VARCHAR(13) — NOT NULL
  • PointCategoryID — INT — NOT NULL
  • PointType — ENUM('Accumulate', 'Use') — NOT NULL
  • ReviewID — INT
  • PointClassification — VARCHAR(50) — NOT NULL
  • PointAmount — INT — NOT NULL
  • PointCreationDate — TIMESTAMP — NOT NULL
  • PointUseDate — TIMESTAMP — NOT NULL

PointMaster

  • PointCategoryID — INT
  • PointCategoryName — VARCHAR(50) — NOT NULL
  • AccumulatedPoints — INT — NOT NULL

ReceivingMethods

  • MethodCode — INT
  • MethodName — VARCHAR(100) — NOT NULL
  • Price — DECIMAL(10, 2) — NOT NULL

Refunds

  • RefundID — INT
  • ReferenceID — INT — NOT NULL
  • MemberID — VARCHAR(13) — NOT NULL
  • RefundRequestDate — TIMESTAMP — NOT NULL
  • RefundCompletionDate — TIMESTAMP — NOT NULL
  • RefundAmount — INT — NOT NULL
  • RefundStatus — ENUM('Requested', 'Completed', 'Rejected') — NOT NULL
  • RefundReason — TEXT — NOT NULL
  • RefundAccount — VARCHAR(50) — NOT NULL

Reviews

  • ReviewID — INT
  • MemberID — VARCHAR(13) — NOT NULL
  • MatchID — INT — NOT NULL
  • GoodsID — INT — NOT NULL
  • ReviewDate — TIMESTAMP — NOT NULL
  • Content — TEXT — NOT NULL
  • Rating — INT — NOT NULL
  • GrantedPoints — INT — NOT NULL

Seats

  • SeatID — INT
  • StadiumID — INT — NOT NULL
  • Section — VARCHAR(50) — NOT NULL
  • RowNumber — VARCHAR(50) — NOT NULL
  • SeatNumber — INT — NOT NULL
  • Price — INT — NOT NULL
  • SeatStatus — ENUM('Available', 'Reserved') — NOT NULL

Teams

  • TeamID — INT
  • TeamName — VARCHAR(50) — NOT NULL
  • KoreanName — VARCHAR(50)
  • StadiumID — INT — NOT NULL
  • FoundingYear — YEAR — NOT NULL
  • Coach — VARCHAR(50) — NOT NULL
  • City — VARCHAR(50) — NOT NULL
  • Introduction — TEXT
  • LeagueCategory — VARCHAR(10) — NOT NULL

TicketDetails

  • TicketDetailID — INT
  • ReservationID — INT — NOT NULL
  • MatchID — INT — NOT NULL
  • SeatID — INT — NOT NULL
  • Price — INT — NOT NULL
  • MembershipDiscountAmount — INT
  • CouponDiscountAmount — INT
  • TotalAmount — INT — NOT NULL
  • IsCanceled — BOOLEAN — NOT NULL
  • CancelDate — TIMESTAMP
  • IsRefunded — BOOLEAN — NOT NULL

Tickets

  • ReservationID — INT
  • MatchID — INT — NOT NULL
  • Quantity — INT — NOT NULL
  • Price — INT — NOT NULL
  • MemberID — VARCHAR(13) — NOT NULL
  • ReservationDate — TIMESTAMP — NOT NULL
  • PaymentMethodCode — VARCHAR(5) — NOT NULL
  • ReservationStatus — ENUM('Pending', 'Completed', 'Refunded') — NOT NULL
  • MethodCode — INT — NOT NULL
  • MemberMembershipID — INT
  • CouponID — INT
  • UsedPoints — INT
  • FinalPaymentAmount — INT — NOT NULL
  • ShippingStartDate — TIMESTAMP
  • ShippingEndDate — TIMESTAMP
  • ShippingStatus — ENUM('Pending', 'Completed')
  • RecipientName — VARCHAR(50) — NOT NULL
  • ShippingAddress — VARCHAR(255) — NOT NULL
  • ShippingRequest — VARCHAR(255)

Wishlists

  • WishlistID — INT
  • MemberID — VARCHAR(13) — NOT NULL
  • TeamID — INT — NOT NULL
  • PlayerID — INT — NOT NULL

경기장 (Stadiums)

  • StadiumID — INT
  • StadiumName — VARCHAR(100) — NOT NULL
  • Location — VARCHAR(255) — NOT NULL
  • Capacity — INT — NOT NULL
  • UsageStatus — ENUM('InUse', 'NotInUse') — NOT NULL
  • ParkingSpaces — INT — NOT NULL
  • StadiumImage — BLOB
  • ContactNumber — VARCHAR(20) — NOT NULL

회원 (Members)

  • 회원ID (MemberID) — VARCHAR(13)
  • 비밀번호 (Password) — VARCHAR(20) — NOT NULL
  • 이름 (Name) — VARCHAR(10) — NOT NULL
  • 주소 (Address) — VARCHAR(255) — NOT NULL
  • 이메일 (Email) — VARCHAR(100) — NOT NULL
  • 연락처 (PhoneNumber) — VARCHAR(20) — NOT NULL
  • 성별 (Gender) — CHAR(1) — NOT NULL
  • 등급 (Grade) — VARCHAR(20) — NOT NULL
  • 포인트 (Points) — INT — NOT NULL
  • 회원가입 날짜 (JoinDate) — DATE — NOT NULL