fintech
Tables (4)
Order (주문)
- id (주문ID) — BIGINT — Primary key — NOT NULL
- user_id (유저ID) — BIGINT — Foreign key → User.id — NOT NULL
- order_date (주문 날짜) — DATETIME — NOT NULL
- status (주문 상태) — VARCHAR(20) — NOT NULL
- total_amount (총 주문 금액) — INT — NOT NULL
OrderItem (주문 상품)
- id (주문 상품 ID) — BIGINT — Primary key — NOT NULL
- order_id (주문 ID) — BIGINT — Foreign key → Order.id — NOT NULL
- product_name (상품명) — VARCHAR(255) — NOT NULL
- unit_price (단가) — INT — NOT NULL
- quantity (수량) — INT — NOT NULL
- total_price (총 금액) — INT — NOT NULL
Payment (결제)
- id (결제ID) — BIGINT — Primary key — NOT NULL
- order_id (주문ID) — BIGINT — Foreign key → Order.id — NOT NULL
- amount (결제 금액) — INT — NOT NULL
- currency (통화 단위) — VARCHAR(3) — NOT NULL
- transaction_id (트랜잭션ID) — VARCHAR(255) — NOT NULL
- payment_method (결제 수단) — VARCHAR(50) — NOT NULL
- payment_status (결제 상태) — VARCHAR(50) — NOT NULL
- requested_at (결제 요청 시간) — DATETIME — NOT NULL
- confirmed_at (결제 승인 시간) — NOT NULL
User (회원)
- id (유저ID) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- name (이름) — VARCHAR(100) — NOT NULL
- phone_number (전화번호) — VARCHAR(20) — NOT NULL