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