skala-mini

Tables (8)

Payments

  • payment_id (결제 ID) — long — Primary key — NOT NULL
  • user_id (id) — long — Foreign key → User.user_id — NOT NULL
  • order_id (주문번호) — long
  • order_name (주문명(티켓명)) — VARCHAR(255)
  • amount (결제 금액) — BIGINT
  • payment_key (Toss 결제 키) — VARCHAR(200)
  • payment_method (결제 수단) — VARCHAR(50)
  • payment_status (결제 상태) — enum('PENDING',COMPLETED', 'FAILED', CANCELED')
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

Refund (Untitled)

  • refund_id (환불 ID) — long — Primary key — NOT NULL
  • payment_id (결제 ID) — long — Foreign key → Payments.payment_id — NOT NULL
  • refund_amount (환불 금액) — BIGINT
  • refund_reason (환불 사유) — VARCHAR(500)
  • refund_status (환불 상태) — enum('PENDING','COMPLETED','FAILED')
  • created_at (생성날짜) — DATETIME
  • updated_at (수정날짜) — DATETIME

Ride

  • ride_id (놀이기구 ID) — long — Primary key — NOT NULL
  • name (놀이기구 이름) — VARCHAR(100)
  • operating_time (운영시간) — varchar(128)
  • is_active (운영여부) — BOOLEAN
  • capacity_total (총 탑승 인원) — BIGINT
  • capacity_premium (프리미엄 탑승 인원) — BIGINT
  • capacity_general (일반 탑승인원) — BIGINT
  • short_description (놀이기구 짧은 설명) — VARCHAR(100)
  • long_description (놀이기구 긴 설명) — VARCHAR(500)
  • photo (놀이기구 사진) — VARCHAR(500)
  • created_at (생성날짜) — DATETIME

Ride_Usage

  • ride_usage_id (놀이기구 사용 ID) — long — Primary key — NOT NULL
  • user_id (유저 ID) — long — Foreign key → User.user_id — NOT NULL
  • ride_id (놀이기구 ID) — long — Foreign key → Ride.ride_id — NOT NULL
  • ticket_order_id (티켓 주문 ID) — long — Foreign key → Ticket Order.ticket_order_id — NOT NULL
  • status (놀이기구 탑승 상태) — enum('WAITED', 'COMPLETED')
  • created_at (생성날짜) — DATETIME
  • completed_at (탑승시간) — DATETIME

Ticket

  • ticket_id (티켓 ID) — long — Primary key — NOT NULL
  • ticket_type (티켓 타입) — enum('GENERAL', 'PREMIUM')
  • ticket_count (티켓 개수) — int
  • price (가격) — int

Ticket Management (Ticket Mabagement)

  • ticket_management_id (티켓 관리 ID) — long — Primary key — NOT NULL
  • ticket_id (티켓 ID) — long — Foreign key → Ticket.ticket_id — NOT NULL
  • available_at (사용 가능 날짜) — DATETIME
  • stock (재고) — BIGINT

Ticket Order

  • ticket_order_id (티켓 주문 ID) — long — Primary key — NOT NULL
  • user_id (유저 ID) — long — Foreign key → User.user_id — NOT NULL
  • ticket_management_id (티켓 관리 ID) — long — Foreign key → Ticket Management.ticket_management_id — NOT NULL
  • payment_date (지불 날짜) — DATETIME
  • active_status (티켓 상태) — enum('ACTIVE','DEACTIVE')

User

  • user_id (유저 ID) — long — Primary key — NOT NULL
  • username (유저 이름) — string
  • password (passowrd) — varchar(64)
  • created_at (생성날짜) — datetime