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