gbswBigvolleyBall
Tables (5)
Order (주문)
- id (PK) — Long — Primary key — NOT NULL
- customer_name (고객 이름) — String
- order_date (주문 날짜) — LocalDate
OrderItem (주문항목)
- id (PK) — Long — Primary key — NOT NULL
- product_name (상품명) — String
- quantity (수량) — int
- prive (가격) — double
- order_id (FK) — Long
member (유저)
- id (pk) — Long — Primary key — NOT NULL
- password (비밀번호) — String
- role (역할) — enum — USER, ADMIN
schedule (경기일정)
- id (pk) — Long — Primary key — NOT NULL
- team1 (팀1) — String
- team2 (팀2) — String
- date (경기 날짜) — LocalDate
- time (경기 시간) — String — LUNCH, DINNER
team (반)
- id (pk) — Long — Primary key — NOT NULL
- grade (학년 반) — Enum — ex) 1-1, 1-2
- recently_game (최근경기) — String
- win (승) — int
- lose (패) — int