졸업프로젝트
테이블 (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