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