bc card
Tables (9)
ITEM (상품)
- Key (product_id) — bigint — Primary key — NOT NULL
- 아이디 (seller_id) — bigint — Foreign key → SELLER.아이디 — NOT NULL
- 가격 (price) — bigint
- 수량 (stock) — bigint
ORDER (주문)
- Key (order_id) — bigint — Primary key — NOT NULL
- Key (user_id2) — bigint — Foreign key → USER.Key — NOT NULL
- 주문자 (user_id) — bigint
- 금액 (total_amount) — bigint
- 시간 (created_at) — timestamp
ORDER_DETAIL (주문상세)
- Key (order_info_id) — bigint — Primary key — NOT NULL
- Key (product_id) — bigint — Foreign key → ITEM.Key — NOT NULL
- Key (order_id) — bigint — Foreign key → ORDER.Key — NOT NULL
- 개별금액 (unit_price) — bigint
- 총금액 (total_price) — bigint
- 수량 (quantity) — bigint
PAYMENT (결제)
- Key (payment_id) — bigint — Primary key — NOT NULL
- Key (order_id) — bigint — Foreign key → ORDER.Key — NOT NULL
- 상태 (payment_status) — enum
- 시간 (created_at) — timestamp
PAYMENT_LOG (결제로그)
- Key (payment_log_id) — bigint — Primary key — NOT NULL
- Key (payment_id) — bigint — Foreign key → PAYMENT.Key — NOT NULL
- Key (payment_method_id) — bigint — Foreign key → PAYMENT_METHOD.Key — NOT NULL
- 상태 (event_type) — enum
- 메시지 (message) — varchar(255)
- 시간 (tiemstamp) — timestamp
PAYMENT_METHOD (결제수단)
- Key (payment_method_id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → USER.Key — NOT NULL
- 결제수단 (payment_type) — enum
- 상세정보 (details) — varchar(255)
REFUND (환불)
- Key (refund_id) — bigint — Primary key — NOT NULL
- Key (payment_id) — bigint — Foreign key → PAYMENT.Key — NOT NULL
- 금액 (refund_amount) — bigint
- 사유 (reason) — varchar(255)
- 상태 (status) — enum
- 시간 (created_at) — timestamp
SELLER (판매자)
- 아이디 (seller_id) — bigint — Primary key — NOT NULL
- 이름 (user_name) — varchar(255)
- 사업자번호 (business_id) — varchar(255)
- 이메일 (contact_email) — varchar(255)
USER (유저)
- Key (user_id) — bigint — Primary key — NOT NULL
- 이름 (user_name) — varchar(255)
- 이메일 (email) — varchar(255)