circul
Tables (9)
client_order
- client_order_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- classification_code — varchar(255) — NOT NULL
- delivery_at — datetime(6)
- hope_delivery_at — datetime(6)
- modifiedyn — varchar(255)
- mother_code — varchar(255) — NOT NULL
- order_mount — int — NOT NULL
- product_code — varchar(255) — NOT NULL
- statementnumber — varchar(255)
- status — varchar(255)
device
- device_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- device_code — varchar(255) — NOT NULL
- device_type — varchar(255) — NOT NULL
- email — varchar(255)
- manager — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- supplier_code — varchar(255) — NOT NULL
discard_history
- discard_history_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- client_code — varchar(255) — NOT NULL
- discard_at — datetime(6)
- product_code — varchar(255) — NOT NULL
- product_serial_code — varchar(255) — NOT NULL
- reason — varchar(255)
- rfid_chip_code — varchar(255) — NOT NULL
- supplier_code — varchar(255) — NOT NULL
member
- member_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- address — varchar(255)
- bank_account_name — varchar(255) — NOT NULL
- bank_account_number — varchar(255) — NOT NULL
- bank_name — varchar(255) — NOT NULL
- business_number — varchar(255) — NOT NULL
- category_business — varchar(255)
- classification_code — varchar(255) — NOT NULL
- client_company — varchar(255)
- email — varchar(255) — NOT NULL
- etc — varchar(255)
- grade — int — NOT NULL
- last_orders — varchar(255)
- login_id — varchar(255) — NOT NULL
- manager — varchar(255) — NOT NULL
- mother_code — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- position — varchar(255)
- represent — varchar(255) — NOT NULL
- state_of_business — varchar(255)
- with_drawal — varchar(255)
- with_drawal_date — datetime(6)
product
- product_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- product_code — varchar(255) — NOT NULL
- product_img_name — varchar(255) — NOT NULL
- product_img_url — varchar(255) — NOT NULL
- product_name — varchar(255) — NOT NULL
- purchase_price — int — NOT NULL
- status — varchar(255) — NOT NULL
- product_qtt — int — NOT NULL
product_detail
- product_detail_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- client_code — varchar(255) — NOT NULL
- cycle — int — NOT NULL
- latest_reading_at — datetime(6) — NOT NULL
- product_code — varchar(255) — NOT NULL
- product_serial_code — varchar(255) — NOT NULL
- rfid_chip_code — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- supplier_code — varchar(255) — NOT NULL
product_detail_history
- product_detail_history_id (Key) — bigint — Primary key — NOT NULL
- rfid_scanhistory_id (Key2) — bigint — Foreign key → rfid_scan_history.rfid_scanhistory_id — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- client_code — varchar(255) — NOT NULL
- cycle — int — NOT NULL
- latest_reading_at — datetime(6) — NOT NULL
- product_code — varchar(255) — NOT NULL
- product_serial_code — varchar(255) — NOT NULL
- rfid_chip_code — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- supplier_code — varchar(255) — NOT NULL
rfid_scan_history
- rfid_scanhistory_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- client_code — varchar(255) — NOT NULL
- device_code — varchar(255) — NOT NULL
- flow_remain_quantity — int
- latest_reading_at — datetime(6) — NOT NULL
- no_return_quantity — int
- product_code — varchar(255) — NOT NULL
- rfid_chip_code — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- status_count — int
- supplier_code — varchar(255) — NOT NULL
- total_remain_quantity — int
supplier_order
- order_id (Key) — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- classification_code — varchar(255) — NOT NULL
- delivery_at — datetime(6)
- order_mount — int — NOT NULL
- product_code — varchar(255) — NOT NULL
- statementnumber — varchar(255)