Aconrn_erp ERD
Tables (16)
AGE_GROUP (Untitled6)
- agegroup_id (Key) — Primary key — NOT NULL
- customer_id (Key3) — Foreign key → CUSTOMER_INFO.customer_id — NOT NULL
- agegroup (Field)
CUSTOMER_GRADE (Untitled4)
- grade_id (Key) — Primary key — NOT NULL
- customer_id (Key3) — Foreign key → CUSTOMER_INFO.customer_id — NOT NULL
- customer_grade (Field)
CUSTOMER_INFO (Untitled2)
- customer_id (Key) — Primary key — NOT NULL
- customer_name (Field)
- customer_gender (Field2)
- customer_birth_date (Field3)
- customer_tel (Field4)
- customer_date (Field5)
CUSTOMER_NOTES (Untitled3)
- note_id (Key) — Primary key — NOT NULL
- customer_id (Key3) — Foreign key → CUSTOMER_INFO.customer_id — NOT NULL
- notes_date (Field)
- notes (Field2)
CUSTOMER_PREFERENCE_DATA (Untitled8)
- preference_data_id (Key) — Primary key — NOT NULL
- item_code (Key3) — Foreign key → ITEM.item_code — NOT NULL
- purchase_code (Key2) — Foreign key → ITEM.purchase_code — NOT NULL
- vendor_code (Key22) — Foreign key → ITEM.vendor_code — NOT NULL
- product_name (Field9)
- total_amount_for_product (Field)
- total_count_for_product (Field2)
- rating (Field3)
- gender_preference (Field4)
- age_preference (Field5)
- region_preference _province (Field6)
- region_preference _city (Field7)
- region_preference _town (Field8)
CUSTOMER_TRANSACTION_INFO (Untitled7)
- transaction_info_id (Key) — Primary key — NOT NULL
- customer_id (Key3) — Foreign key → CUSTOMER_INFO.customer_id — NOT NULL
- total_amount_for_customer (Field)
- top_selling_product (Field2)
- total_count_for_customer (Field3)
- most_purchased_product (Field4)
DELIVERY (Untitled10)
- delivery_num (Key) — Primary key — NOT NULL
- order_num (Key3) — Foreign key → ORDER.order_num — NOT NULL
- item_code (Field)
- item_name (Field2)
- cs_id (Field3)
- cs_name (Field4)
- cs_phone_number (Field5)
- cs_addr (Field6)
- delivery_date (Field7)
- delivery_comp (Field8)
DISTRIBUTION (Untitled15)
- distribution_code (Key) — Primary key — NOT NULL
- purchase_code (Key2) — Foreign key → PURCHASE.purchase_code — NOT NULL
- vendor_code (Key22) — Foreign key → PURCHASE.vendor_code — NOT NULL
- distribution_name (Field)
- receipt_date (Field2)
- order_qty (Field3)
- initial_qty (Field4)
- received_qty (Field5)
- release_qty (Field6)
- current_qty (Field7)
- expected_recepit_date (Field8)
ITEM (Untitled12)
- item_code (Key) — Primary key — NOT NULL
- purchase_code (Key2) — Foreign key → PURCHASE.purchase_code — NOT NULL
- vendor_code (Key22) — Foreign key → PURCHASE.vendor_code — NOT NULL
- item_type (Field)
- item_name (Field2)
- item_status (Field3)
- item_price (Field4)
- item_qty (Field5)
ORDER (Untitled9)
- order_num (Key) — Primary key — NOT NULL
- item_code (Field)
- item_name (Field2)
- cs_id (Field3)
- cs_name (Field4)
- cs_tel (Field5)
- cs_addr (Field6)
- item_unit_price (Field7)
- order_quantity (Field8)
- delievry_fee (Field9)
- order_total_price (Field10)
- order_date (Field11)
- item_req (Field12)
- order_status (Field13)
PURCHASE (Untitled14)
- purchase_code (Key) — Primary key — NOT NULL
- vendor_code (Key2) — Foreign key → VENDOR.vendor_code — NOT NULL
- purchase_name (Field)
- purchase_unit (Field2)
- order_date (Field3)
- order_qty (Field4)
- price (Field5)
- remark (Field6)
REGION_GROUP (Untitled5)
- regiongroup_id (Key) — Primary key — NOT NULL
- customer_id (Key3) — Foreign key → CUSTOMER_INFO.customer_id — NOT NULL
- regiongroup_province (Field)
- regiongroup_city (Field2)
- regiongroup_town (Field3)
RESERVATION (Untitled13)
- rs_num (Key) — Primary key — NOT NULL
- customer_id (Key2) — Foreign key → CUSTOMER_INFO.customer_id — NOT NULL
- rs_order (Field)
- rs_name (Field2)
- rs_date (Field3)
- rs_status (Field4)
- add_req (Field5)
- class_name (Field6)
- class_fee (Field7)
RETURN (Untitled11)
- return_num (Key) — Primary key — NOT NULL
- order_num (Key3) — Foreign key → ORDER.order_num — NOT NULL
- return_type (Field)
- item_name (Field2)
- cs_name (Field3)
- cs_phone_number (Field4)
- order_quantity (Field5)
- order_total_price (Field6)
- order_date (Field7)
- return_reason (Field8)
- return_status (Field9)
USER_INFO (Untitled)
- id (Key2) — NUMBER — Primary key — NOT NULL
- email (Key) — NOT NULL
- password (Field)
- shop_name (Field2)
- registration_num (Field3)
VENDOR (Untitled16)
- vendor_code (Key) — Primary key — NOT NULL
- vendor_name (Field)
- vendor_p (Field2)
- vendor_addr (Field3)
- remark (Field4)
- deliverable_status (Field5)