123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400 |
- propel:
- # catalyz
- node_home:
- id:
- node_id: { type: integer, foreignTable: node, foreignReference: id, onDelete: cascade }
- edito_title: { type: varchar(255) }
- edito_content: { type: longvarchar }
- node_page:
- id:
- node_id: { type: integer, foreignTable: node, foreignReference: id, onDelete: cascade }
- content: { type: longvarchar }
- node_news:
- id:
- node_id: { type: integer, foreignTable: node, foreignReference: id, onDelete: cascade }
- published_at: { type: timestamp }
- introduction: { type: longvarchar }
- content: { type: longvarchar }
- picture: { type: varchar(255) }
- node_network:
- id:
- node_id: { type: integer, foreignTable: node, foreignReference: id, onDelete: cascade }
- introduction: { type: longvarchar }
- # admin
- katao_config:
- id:
- katao_member_id: { type: integer, foreignTable: katao_member, foreignReference: id, onDelete: cascade }
- name: { type: varchar, size: 255, required: true }
- address: { type: longvarchar }
- phone: { type: varchar, size: 255, required: true }
- email: { type: varchar, size: 255, required: true }
- siret_number: { type: char, size: 14, required: true }
- tva_number: { type: char, size: 13, required: true }
- rcs_number: { type: varchar, size: 255, required: true }
- capital: { type: integer, required: true }
- initial_transactions_count: { type: integer, default: 0 }
- initial_transactions_sum: { type: float, default: 0 }
- default_product_picture: { type: varchar(255) }
- default_product_margin: { type: integer, default: 15 }
- default_product_sol_percent: { type: integer, default: 5 }
- mailing_list_email: { type: varchar, size: 255 }
- cart_validation_days_number: { type: integer, required: true, default: 1 }
- accounting_code_prefix_purchase: { type: varchar(12), required: true }
- accounting_code_prefix_sell: { type: varchar(12), required: true }
- accounting_code_bank: { type: varchar(12), required: true }
- accounting_code_bank_sol: { type: varchar(12), required: true }
- accounting_code_credit: { type: varchar(12), required: true }
- accounting_code_error_adjustment_positive: { type: varchar(12), required: true }
- accounting_code_error_adjustment_negative: { type: varchar(12), required: true }
- accounting_code_sol_discount: { type: varchar(12), required: true }
- accounting_code_fees_shipping: { type: varchar(12), required: true }
- accounting_code_fees_billing: { type: varchar(12), required: true }
- accounting_code_discount: { type: varchar(12), required: true }
- member_fee: { type: float, default: 0 }
- additional_currency_name: { type: varchar(255) }
- debug_email: { type: varchar(255) }
- bank_name: { type: varchar(255) }
- bank_account: { type: varchar(255) }
- katao_node:
- id:
- city: { type: varchar, size: 255, required: true }
- responsible: { type: integer, foreignTable: katao_user, foreignReference: id, required: false, onDelete: setnull }
- begin_at: { type: timestamp, required: true }
- is_default: { type: integer, size: 1, default: 0 }
- created_at:
- updated_at:
- katao_period:
- id:
- name: { type: varchar, size: 255, required: true }
- begin_at: { type: timestamp, required: true }
- finish_at: { type: timestamp, required: true }
- order_ended_at: { type: timestamp, required: true }
- status: { type: integer, required: true, default: 1 } # 1 : provisoire, 2 : active, 3 : terminée
- exported: { type: integer, size: 1, default: 0 }
- created_at:
- updated_at:
- katao_product_category:
- id:
- name: { type: varchar, size: 255, required: true }
- url_identifier: { type: varchar, size: 255, required: true }
- accounting_code_suffix: { type: varchar(12), required: true }
- sort_order: { type: integer, default: 0 }
- created_at:
- updated_at:
- katao_product_family:
- id:
- katao_product_category_id: { type: integer, foreignTable: katao_product_category, foreignReference: id, required: true, onDelete: cascade }
- name: { type: varchar, size: 255, required: true }
- url_identifier: { type: varchar, size: 255, required: true }
- created_at:
- updated_at:
- katao_product:
- id:
- reference: { type: varchar(255) }
- name: { type: varchar, size: 255, required: true }
- url_identifier: { type: varchar, size: 255, required: true }
- description: { type: longvarchar }
- katao_product_family_id: { type: integer, foreignTable: katao_product_family, foreignReference: id, required: true, onDelete: cascade }
- katao_supplier_id: { type: integer, foreignTable: katao_supplier, foreignReference: id, required: true, onDelete: cascade }
- max_sol_amount: { type: integer }
- unit_price_euro: { type: float, required: true }
- authorize_decimal: { type: boolean, size: 1, default: false }
- margin: { type: float }
- tva_rate: { type: float, default: 0 }
- min_order_number: { type: integer, required: true, default: 1 }
- picture: { type: varchar(255) }
- delivery_delay: { type: integer }
- is_archived: { type: integer, size: 1, default: 0 }
- accounting_code_purchase: { type: varchar(12), required: true }
- accounting_code_sell: { type: varchar(12), required: true }
- created_at:
- updated_at:
- katao_user:
- id:
- katao_member_id: { type: integer, foreignTable: katao_member, foreignReference: id, onDelete: cascade }
- katao_supplier_id: { type: integer, foreignTable: katao_supplier, foreignReference: id, onDelete: cascade }
- status: { type: integer, required: true, default: 2 } # 1 : contact, 2 : actif, 3 : inactif
- email: { type: varchar, size: 255 }
- address1: { type: varchar, size: 255, required: true }
- address2: { type: varchar, size: 255 }
- zip: { type: varchar, size: 255 }
- city: { type: varchar, size: 255, required: true }
- phone: { type: varchar, size: 255 }
- fax: { type: varchar, size: 255 }
- gmap_lng: { type: double }
- gmap_lat: { type: double }
- login: { type: varchar, size: 255, required: true }
- password: { type: varchar, size: 255, required: true }
- is_seo: { type: integer, size: 1, default: 0 }
- is_admin: { type: integer, size: 1, default: 0 }
- created_at:
- updated_at:
- katao_member:
- id:
- katao_index: { type: integer, required: true }
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- next_katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, onDelete: setnull }
- katao_member_id: { type: integer, foreignTable: katao_member, foreignReference: id, onDelete: setnull }
- first_name: { type: varchar, size: 255, required: true }
- last_name: { type: varchar, size: 255, required: true }
- accounting_code: { type: char, size: 6, required: true }
- accounting_code_sol: { type: char, size: 6, required: true }
- initial_amount_euro: { type: float, default: 0 }
- initial_amount_sol: { type: integer, default: 0 }
- is_referer: { type: integer, size: 1, default: 0 }
- is_delegate: { type: integer, size: 1, default: 0 }
- is_anonymous: { type: integer, size: 1, default: 0 }
- is_member: { type: integer, size: 1, default: 1 }
- card_number_sol: { type: char, size: 8 }
- user_situation: { type: varchar, size: 255 }
- user_birthday: { type: date }
- parrain_name: { type: varchar, size: 255 }
- # member_group: { type: integer, foreignTable: katao_member_group, foreignReference: id }
- created_at:
- updated_at:
- katao_supplier:
- id:
- katao_index: { type: integer, required: true }
- member_id: { type: integer, foreignTable: katao_member, foreignReference: id, onDelete: cascade }
- referer_id: { type: integer, foreignTable: katao_member, foreignReference: id, onDelete: cascade }
- name: { type: varchar, size: 255, required: true }
- url_identifier: { type: varchar, size: 255, required: true }
- presentation: { type: longvarchar }
- email: { type: varchar, size: 255 }
- address1: { type: varchar, size: 255, required: true }
- address2: { type: varchar, size: 255 }
- zip: { type: varchar, size: 255 }
- city: { type: varchar, size: 255, required: true }
- phone: { type: varchar, size: 255 }
- fax: { type: varchar, size: 255 }
- website: { type: varchar, size: 255 }
- gmap_lng: { type: double }
- gmap_lat: { type: double }
- accounting_code: { type: char, size: 6, required: true }
- accounting_code_sol: { type: char, size: 6, required: true }
- siret_number: { type: char, size: 14, required: true, index: unique }
- is_global: { type: integer, size: 1, default: 0 }
- order_min_amount: { type: float, default: 0 }
- created_at:
- updated_at:
- katao_supplier_node:
- katao_supplier_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_supplier, onDelete: cascade, onUpdate: cascade, required: true }
- katao_node_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_node, onDelete: cascade, onUpdate: cascade, required: true }
- katao_node_product:
- id:
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_product_id: { type: integer, foreignTable: katao_product, foreignReference: id, required: true, onDelete: cascade }
- katao_node_supplier:
- id:
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_supplier_id: { type: integer, foreignTable: katao_supplier, foreignReference: id, required: true, onDelete: cascade }
- include_all_products: { type: integer, size: 1, default: 0, required: true }
- katao_period_product:
- id:
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_product_id: { type: integer, foreignTable: katao_product, foreignReference: id, required: true, onDelete: cascade }
- katao_period_supplier:
- id:
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_supplier_id: { type: integer, foreignTable: katao_supplier, foreignReference: id, required: true, onDelete: cascade }
- include_all_products: { type: integer, size: 1, default: 0, required: true }
- katao_cart:
- id:
- katao_user_id: { type: integer, foreignTable: katao_user, foreignReference: id, required: true, onDelete: cascade }
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- status: { type: integer, required: true, default: 1 } # 1 : en cours, 2 : validé, 3 : archivé
- created_at:
- updated_at:
- katao_cart_product:
- id:
- katao_cart_id: { type: integer, foreignTable: katao_cart, foreignReference: id, required: true, onDelete: cascade }
- katao_product_id: { type: integer, foreignTable: katao_product, foreignReference: id, required: true, onDelete: cascade }
- product_reference: { type: varchar(255) }
- product_name: { type: varchar, size: 255, required: true }
- product_price_euro: { type: float, required: true }
- product_margin: { type: float }
- product_tva_rate: { type: float, default: 0 }
- quantity: { type: integer, required: true, default: 1 }
- quantity_adjusted: { type: integer, default: 0 }
- has_been_adjusted: { type: integer, size: 1, default: 0 }
- quantity_delivered: { type: integer, default: 0 }
- katao_order_product_id: { type: integer, foreignTable: katao_order_product, foreignReference: id, onDelete: setnull }
- created_at:
- updated_at:
- katao_order:
- id:
- katao_supplier_id: { type: integer, foreignTable: katao_supplier, foreignReference: id, required: true, onDelete: cascade }
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- status: { type: integer, required: true, default: 1 } # 1 : générée, 2 : ajustée, 3 : envoyée, 4 : réceptionnée, 5 : distribuée
- is_simulated: { type: integer, size: 1, default: 0 }
- supplier_name: { type: varchar, size: 255, required: true }
- supplier_email: { type: varchar, size: 255, required: true }
- supplier_address1: { type: varchar, size: 255, required: true }
- supplier_address2: { type: varchar, size: 255 }
- supplier_zip: { type: varchar, size: 255 }
- supplier_city: { type: varchar, size: 255, required: true }
- katao_name: { type: varchar, size: 255, required: true }
- katao_address: { type: longvarchar }
- katao_siret_number: { type: char, size: 14, required: true }
- katao_rcs_number: { type: varchar, size: 255, required: true }
- katao_capital: { type: integer, required: true }
- delivery_address: { type: longvarchar }
- created_at:
- updated_at:
- katao_order_product:
- id:
- katao_order_id: { type: integer, foreignTable: katao_order, foreignReference: id, onDelete: cascade }
- katao_product_id: { type: integer, foreignTable: katao_product, foreignReference: id, onDelete: cascade }
- product_reference: { type: varchar(255) }
- product_name: { type: varchar, size: 255, required: true }
- product_price_euro: { type: float, required: true }
- product_margin: { type: float }
- product_tva_rate: { type: float, default: 0 }
- quantity: { type: integer, required: true, default: 1 }
- quantity_received: { type: integer, default: 0 }
- quantity_delivered: { type: integer, default: 0 }
- has_been_received: { type: integer, size: 1, default: 0 }
- has_been_delivered: { type: integer, size: 1, default: 0 }
- created_at:
- updated_at:
- katao_invoice:
- id:
- katao_member_id: { type: integer, foreignTable: katao_member, foreignReference: id, required: true, onDelete: cascade }
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- katao_cart_id: { type: integer, foreignTable: katao_cart, foreignReference: id, onDelete: cascade }
- status: { type: integer, required: true, default: 1 } # 1 : générée, 2 : distribuée, 3 : validée, 4 : envoyée
- member_first_name: { type: varchar, size: 255, required: true }
- member_last_name: { type: varchar, size: 255, required: true }
- member_email: { type: varchar, size: 255, required: true }
- member_address1: { type: varchar, size: 255, required: true }
- member_address2: { type: varchar, size: 255 }
- member_zip: { type: varchar, size: 255 }
- member_city: { type: varchar, size: 255, required: true }
- katao_name: { type: varchar, size: 255, required: true }
- katao_address: { type: longvarchar }
- katao_siret_number: { type: char, size: 14, required: true }
- katao_rcs_number: { type: varchar, size: 255, required: true }
- katao_capital: { type: integer, required: true }
- sol_amount: { type: integer, default: 0 }
- created_at:
- updated_at:
- katao_invoice_product:
- id:
- katao_invoice_id: { type: integer, foreignTable: katao_invoice, foreignReference: id, required: true, onDelete: cascade }
- katao_product_id: { type: integer, foreignTable: katao_product, foreignReference: id, required: true, onDelete: cascade }
- katao_cart_product_id: { type: integer, foreignTable: katao_cart_product, foreignReference: id, required: true, onDelete: cascade }
- katao_order_product_id: { type: integer, foreignTable: katao_order_product, foreignReference: id, required: true, onDelete: cascade }
- product_reference: { type: varchar(255) }
- product_name: { type: varchar, size: 255, required: true }
- product_price_euro: { type: float, required: true }
- product_margin: { type: float }
- product_tva_rate: { type: float, default: 0 }
- quantity: { type: integer, required: true, default: 1 }
- quantity_delivered: { type: integer, default: 0 }
- sol_amount: { type: integer, default: 0 }
- created_at:
- updated_at:
- katao_member_deposit:
- id:
- katao_member_id: { type: integer, foreignTable: katao_member, foreignReference: id, required: true, onDelete: cascade }
- amount: { type: float, required: true }
- comment: { type: longvarchar }
- currency: { type: integer, required: true, default: 1 } # 1 : euro, 2 : sol
- payment_mode: { type: integer, default: 0 } # 0 : autre, 1 : espèce, 2 : chèque, 3 : virement, 4 : avoir
- check_number: { type: varchar, size: 255 }
- check_bank: { type: varchar, size: 255 }
- check_deposit: { type: varchar, size: 255 }
- status: { type: integer, required: true, default: 1 } # 1 : validé, 2 : provisoire
- valued_at: { type: timestamp }
- valid_until: { type: timestamp }
- created_at:
- updated_at:
- katao_member_node:
- id:
- katao_member_id: { type: integer, foreignTable: katao_member, foreignReference: id, required: true, onDelete: cascade }
- katao_node_id: { type: integer, foreignTable: katao_node, foreignReference: id, required: true, onDelete: cascade }
- created_at:
- katao_supplier_invoice:
- id:
- katao_supplier_id: { type: integer, foreignTable: katao_supplier, foreignReference: id, required: true, onDelete: cascade }
- katao_period_id: { type: integer, foreignTable: katao_period, foreignReference: id, required: true, onDelete: cascade }
- status: { type: integer, required: true, default: 1 } # 1 : reçue, 2 : payée
- supplier_name: { type: varchar, size: 255, required: true }
- supplier_email: { type: varchar, size: 255, required: true }
- supplier_address1: { type: varchar, size: 255, required: true }
- supplier_address2: { type: varchar, size: 255 }
- supplier_zip: { type: varchar, size: 255 }
- supplier_city: { type: varchar, size: 255, required: true }
- katao_name: { type: varchar, size: 255, required: true }
- katao_address: { type: longvarchar }
- katao_siret_number: { type: char, size: 14, required: true }
- katao_rcs_number: { type: varchar, size: 255, required: true }
- katao_capital: { type: integer, required: true }
- reference: { type: varchar(255) }
- invoice_date: { type: timestamp, required: true }
- due_date: { type: timestamp, required: true }
- payment_date: { type: timestamp }
- payment_mode: { type: integer, required: true, default: 1 } # 1 : virement, 2 : CB, 3 : chèque
- payment_details: { type: varchar, size: 255 }
- payment_amount_euro: { type: float, default: 0 }
- payment_amount_sol: { type: float, default: 0 }
- taux0_bases_ht: { type: float, default: 0 } # Taux de TVA : 0
- taux0_discount_ht: { type: float, default: 0 }
- taux0_amount: { type: float, default: 0 }
- taux1_bases_ht: { type: float, default: 0 } # Taux de TVA : 20%
- taux1_discount_ht: { type: float, default: 0 }
- taux1_amount: { type: float, default: 0 }
- taux2_bases_ht: { type: float, default: 0 } # Taux de TVA : 5.5%
- taux2_discount_ht: { type: float, default: 0 }
- taux2_amount: { type: float, default: 0 }
- total_ht: { type: float, default: 0 }
- total_tva: { type: float, default: 0 }
- comment: { type: longvarchar }
- fees_shipping_ht: { type: float, default: 0 }
- fees_shipping_rate: { type: float, default: 0 }
- fees_shipping_tva: { type: float, default: 0 }
- fees_billing_ht: { type: float, default: 0 }
- fees_billing_rate: { type: float, default: 0 }
- fees_billing_tva: { type: float, default: 0 }
- created_at:
- updated_at:
- katao_supplier_invoice_product:
- id:
- katao_supplier_invoice_id: { type: integer, foreignTable: katao_supplier_invoice, foreignReference: id, onDelete: cascade }
- katao_product_id: { type: integer, foreignTable: katao_product, foreignReference: id, onDelete: cascade }
- product_reference: { type: varchar(255) }
- product_name: { type: varchar, size: 255, required: true }
- product_price_euro: { type: float, required: true }
- product_margin: { type: float }
- product_tva_rate: { type: float, default: 0 }
- quantity: { type: integer, required: true, default: 1 }
- product_price_total: { type: float, default: 0 }
- created_at:
- updated_at:
- katao_supplier_invoice_order:
- katao_supplier_invoice_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_supplier_invoice, onDelete: cascade, onUpdate: cascade, required: true }
- katao_order_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_order, onDelete: cascade, onUpdate: cascade, required: true }
- katao_supplier_product_category:
- katao_supplier_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_supplier, onDelete: cascade, onUpdate: cascade, required: true }
- katao_product_category_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_product_category, onDelete: cascade, onUpdate: cascade, required: true }
- katao_member_group:
- id:
- katao_member_group_name: { type: varchar(255) }
- katao_assoc_member_group:
- member_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_member, required: true, onDelete: cascade }
- group_id: { type: integer, primaryKey: true, foreignReference: id, foreignTable: katao_member_group, required: true, onDelete: cascade }
- katao_member_adhesion:
- id:
- katao_user_id: { type: integer, foreignReference: id, foreignTable: katao_user, required: true }
- year: { type: date, required: true }
- amount: { type: float, required: true }
- type: { type: integer, size: 2 }
- payment_kind: { type: integer, required: true }
- check_no: { type: varchar(255) }
|