| 967 | | || '''R1''' (Product) || productId, product_name, product_description, product_sku, product_unit_price, product_reorder_level, categoryId, supplierId || productId || |
| 968 | | || '''R2''' (Sale) || saleId, sale_date_time, sale_total_amount, userId, customerId, warehouseId || saleId || |
| 969 | | || '''R3''' (!PurchaseOrder) || poId, po_order_date, po_expected_delivery_date, po_status, supplierId, warehouseId || poId || |
| 970 | | || '''R4''' (!SaleItem) || saleId, productId, saleitem_quantity, saleitem_unit_price_at_sale || {saleId, productId} || |
| 971 | | || '''R5''' (!PurchaseOrderItem) || poId, productId, poitem_quantity, poitem_unit_cost || {poId, productId} || |
| 972 | | || '''R6''' (User) || userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active || userId || |
| 973 | | || '''R7''' (Customer) || customerId, customer_name, customer_email, customer_phone, customer_address || customerId || |
| 974 | | || '''R8''' (Category) || categoryId, category_name, category_description || categoryId || |
| 975 | | || '''R9''' (Supplier) || supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address || supplierId || |
| 976 | | || '''R10''' (Warehouse) || warehouseId, warehouse_name, warehouse_location, warehouse_capacity || warehouseId || |
| 977 | | || '''R11''' (!WarehouseStock) || warehouseId, productId, stock_quantity_on_hand, stock_last_updated || {warehouseId, productId} || |
| | 967 | || '''Verification_Token''' || token_created_at, token_expired_at, user_id || verification_token_uuid || |
| | 968 | || '''Meeting_Reminder''' || meeting_at, meeting_scheduled_at, meeting_sent, meeting_link, user_id || meeting_reminder_id || |
| | 969 | || '''Expert''' || expert_name, expert_email, expert_login_provider, expert_password_hash || expert_id || |
| | 970 | || '''Tag_Translate''' || tag_translate_language, tag_value, tag_id || tag_translate_id || |
| | 971 | || '''Course_Translate''' || course_translate_language, course_title_short, course_title, course_description_short, course_description, course_description_long, course_id || course_translate_id || |
| | 972 | || '''Course_Content_Translate''' || content_translate_title, content_translate_language, course_content_id || course_content_translate_id || |
| | 973 | || '''Course_Lecture_Translate''' || lecture_title, lecture_language, lecture_content_file_name, lecture_description, lecture_content_text, course_lecture_id || course_lecture_translate_id || |
| | 974 | || '''User_Course_Progress''' || progress_completed, progress_completed_at, enrollment_id, course_lecture_id || user_course_progress_id || |
| | 975 | || '''User''' || user_name, user_email, user_login_provider, user_password_hash, user_verified, user_profile_complete, user_used_free_consultation, user_company_size, user_work_position, user_points || user_id || |
| | 976 | || '''Course''' || course_image_url, course_color, course_difficulty, course_duration_minutes, course_price || course_id || |
| | 977 | || '''Enrollment''' || enrollment_status, enrollment_purchase_date, enrollment_activation_date, enrollment_completion_date, user_id, course_version_id, payment_id, review_id || enrollment_id || |
| | 978 | || '''Payment''' || payment_amount, payment_date, payment_method, payment_status, enrollment_id || payment_id || |
| | 979 | || '''Review''' || review_rating, review_comment, review_date, enrollment_id || review_id || |
| | 980 | || '''Tag''' || tag_type || tag_id || |
| | 981 | || '''Course_Version''' || version_number, version_creation_date, version_active, course_id || course_version_id || |
| | 982 | || '''Course_Content''' || content_position, course_version_id || course_content_id || |
| | 983 | || '''Course_Lecture''' || lecture_duration_minutes, lecture_position, lecture_content_type, course_content_id || course_lecture_id || |
