ProductOrder
Tables (10)
UT_ORDERS (주문테이블)
- PK (order_id) — Long — Primary key — NOT NULL
- FK (customer_id) — Long — NOT NULL
- Field
UT_ORDER_GOODS (주문 여행용품 테이블)
- PK (order_goods_id) — Long — Primary key — NOT NULL
- FK (order_id) — Long — Foreign key → UT_ORDERS.PK — NOT NULL
- Field
- Field2
- Field3
UT_ORDER_GOODS_UNITS (주문 여행용품 상품 1개 단위)
- PK (order_goods_unit_id) — Long — Primary key — NOT NULL
- FK (order_goods_id) — Long — Foreign key → UT_ORDER_GOODS.PK — NOT NULL
UT_ORDER_INPUT_OPTIONS (주문 작성형 옵션 테이블)
- PK (order_input_option_id) — Long — Primary key — NOT NULL
- PK (order_goods_id) — Long — Foreign key → UT_ORDER_GOODS.PK — NOT NULL
UT_ORDER_SHIPMENTS (주문 배송 관리)
- PK (order_shipment_id) — Primary key — NOT NULL
- Field
- Field2
UT_ORDER_SHIPMENT_UNIT (Untitled4)
- PK (order_shipment_unit_id) — Primary key — NOT NULL
- FK (order_shipment_id) — Foreign key → UT_ORDER_SHIPMENTS.PK — NOT NULL
- FK (order_goods_unit_id) — Long — Foreign key → UT_ORDER_GOODS_UNITS.PK — NOT NULL
UT_ORDER_SHIPPING_ADDRESS_SNAPSHOTS (Untitled2)
- PK (order_shipping_add_id) — Long — Primary key — NOT NULL
- FK (order_id) — Long — Foreign key → UT_ORDERS.PK — NOT NULL
UT_PAYMENTS (결제 테이블)
- PK (payment_id) — Long — Primary key — NOT NULL
- FK (order_id) — Long — Foreign key → UT_ORDERS.PK — NOT NULL
UT_PAYMENT_PROD_ALLOCATIONS (Untitled3)
- PK (payment_allocation_id) — Long — Primary key — NOT NULL
- 결제 트랜젝션 ID (payment_trasaction_id) — Long — Foreign key → UT_PAYMENT_TRANSACTIONS.결제 트랜젝션 ID — NOT NULL
UT_PAYMENT_TRANSACTIONS (Untitled)
- 결제 트랜젝션 ID (payment_trasaction_id) — Long — Primary key — NOT NULL
- 결제 id (payment_id) — Long — Foreign key → UT_PAYMENTS.PK — NOT NULL