zendesk unique ticket

Tables (4)

deliveries (Untitled4)

  • delivery_number (Key) — text — Primary key — NOT NULL
  • address (Field) — text
  • recipient (Field2) — text
  • memo (Field3) — text
  • order_product_number (Key2) — text — Foreign key → order_items.order_product_number — NOT NULL

order (Untitled2)

  • order_number (Key) — text — Primary key — NOT NULL — 주문번호 OR00001
  • user_id (2) — number — Foreign key → user.user_id — NOT NULL

order_items (Untitled3)

  • order_product_number (Key) — text — Primary key — NOT NULL
  • product_name (Field) — text
  • item_status (Field2) — enum
  • quantity (Field3) — number
  • order_number (Key2) — text — Foreign key → order.order_number — NOT NULL — 주문번호 OR00001

user (Untitled)

  • user_id — number — Primary key — NOT NULL
  • name (Field) — text