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)