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