354 lines
6.6 KiB
YAML
354 lines
6.6 KiB
YAML
---
|
|
propel:
|
|
_attributes:
|
|
defaultIdMethod: native
|
|
package: plugins.stInvoicePlugin.lib.model
|
|
st_invoice:
|
|
_attributes:
|
|
phpName: Invoice
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
invoice_user_seller_id:
|
|
type: INTEGER
|
|
required: false
|
|
foreignTable: st_invoice_user_seller
|
|
foreignReference: id
|
|
onDelete: restrict
|
|
invoice_user_customer_id:
|
|
type: INTEGER
|
|
required: false
|
|
foreignTable: st_invoice_user_customer
|
|
foreignReference: id
|
|
onDelete: restrict
|
|
order_id:
|
|
type: INTEGER
|
|
foreignTable: st_order
|
|
foreignReference: id
|
|
onDelete: setnull
|
|
invoice_currency_id:
|
|
type: INTEGER
|
|
foreignTable: st_invoice_currency
|
|
foreignReference: id
|
|
onDelete: restrict
|
|
invoice_proforma_id:
|
|
type: INTEGER
|
|
company_description:
|
|
type: LONGVARCHAR
|
|
invoice_description:
|
|
type: LONGVARCHAR
|
|
opt_customer_company:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_customer_full_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_customer_vat_number:
|
|
type: VARCHAR
|
|
size: 255
|
|
order_discount:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
date_selle:
|
|
type: DATE
|
|
date_create_copy:
|
|
type: DATE
|
|
number:
|
|
type: VARCHAR
|
|
size: 45
|
|
signature_seller:
|
|
type: VARCHAR
|
|
size: 45
|
|
signature_customer:
|
|
type: VARCHAR
|
|
size: 45
|
|
opt_total_ammount_brutto:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
town:
|
|
type: VARCHAR
|
|
size: 255
|
|
curency:
|
|
type: VARCHAR
|
|
size: 20
|
|
max_day:
|
|
type: VARCHAR
|
|
size: 20
|
|
default: none
|
|
payment_type:
|
|
type: VARCHAR
|
|
size: 20
|
|
default: none
|
|
is_proforma:
|
|
type: BOOLEAN
|
|
default: 1
|
|
is_request:
|
|
type: BOOLEAN
|
|
default: 0
|
|
is_confirm:
|
|
type: BOOLEAN
|
|
default: 0
|
|
is_draft:
|
|
type: BOOLEAN
|
|
default: false
|
|
_indexes:
|
|
order_number:
|
|
- date_create_copy
|
|
st_invoice_status:
|
|
_attributes:
|
|
phpName: InvoiceStatus
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
invoice_id:
|
|
type: INTEGER
|
|
required: true
|
|
foreignTable: st_invoice
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
payment_id:
|
|
type: INTEGER
|
|
default: 0
|
|
opt_payment_type_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
opt_payment_status:
|
|
type: BOOLEAN
|
|
default: 0
|
|
opt_payment_type_id:
|
|
type: INTEGER
|
|
hand_mod:
|
|
type: BOOLEAN
|
|
default: 0
|
|
paid_amount:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
st_invoice_product:
|
|
_attributes:
|
|
phpName: InvoiceProduct
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
invoice_id:
|
|
type: INTEGER
|
|
required: true
|
|
foreignTable: st_invoice
|
|
foreignReference: id
|
|
onDelete: cascade
|
|
product_id:
|
|
type: INTEGER
|
|
foreignTable: st_product
|
|
foreignReference: id
|
|
onDelete: setnull
|
|
name:
|
|
type: VARCHAR
|
|
size: 1024
|
|
code:
|
|
type: VARCHAR
|
|
size: 255
|
|
pkwiu:
|
|
type: VARCHAR
|
|
size: 255
|
|
quantity:
|
|
type: DECIMAL
|
|
size: 8
|
|
scale: 2
|
|
measure_unit:
|
|
type: VARCHAR
|
|
size: 20
|
|
discount:
|
|
type: FLOAT
|
|
price_netto:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
price_brutto:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
vat:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
vat_id:
|
|
type: INTEGER
|
|
total_price_netto:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
vat_ammount:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
opt_total_price_brutto:
|
|
type: DECIMAL
|
|
size: 10
|
|
scale: 2
|
|
is_delivery:
|
|
type: BOOLEAN
|
|
default: false
|
|
st_invoice_user_customer:
|
|
_attributes:
|
|
phpName: InvoiceUserCustomer
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
country:
|
|
type: VARCHAR
|
|
size: 255
|
|
full_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
name:
|
|
type: VARCHAR
|
|
size: 1024
|
|
surname:
|
|
type: VARCHAR
|
|
size: 255
|
|
address:
|
|
type: VARCHAR
|
|
size: 1024
|
|
address_more:
|
|
type: VARCHAR
|
|
size: 1024
|
|
region:
|
|
type: VARCHAR
|
|
size: 1024
|
|
street:
|
|
type: VARCHAR
|
|
size: 1024
|
|
house:
|
|
type: VARCHAR
|
|
size: 1024
|
|
flat:
|
|
type: VARCHAR
|
|
size: 1024
|
|
code:
|
|
type: VARCHAR
|
|
size: 1024
|
|
town:
|
|
type: VARCHAR
|
|
size: 1024
|
|
company:
|
|
type: VARCHAR
|
|
size: 255
|
|
vat_number:
|
|
type: VARCHAR
|
|
size: 255
|
|
pesel:
|
|
type: VARCHAR
|
|
size: 1024
|
|
crypt:
|
|
type: INTEGER
|
|
default: 0
|
|
st_invoice_user_seller:
|
|
_attributes:
|
|
phpName: InvoiceUserSeller
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
country:
|
|
type: VARCHAR
|
|
size: 255
|
|
full_name:
|
|
type: VARCHAR
|
|
size: 255
|
|
name:
|
|
type: VARCHAR
|
|
size: 1024
|
|
surname:
|
|
type: VARCHAR
|
|
size: 255
|
|
address:
|
|
type: VARCHAR
|
|
size: 1024
|
|
address_more:
|
|
type: VARCHAR
|
|
size: 1024
|
|
region:
|
|
type: VARCHAR
|
|
size: 1024
|
|
street:
|
|
type: VARCHAR
|
|
size: 1024
|
|
house:
|
|
type: VARCHAR
|
|
size: 1024
|
|
flat:
|
|
type: VARCHAR
|
|
size: 1024
|
|
code:
|
|
type: VARCHAR
|
|
size: 1024
|
|
town:
|
|
type: VARCHAR
|
|
size: 1024
|
|
company:
|
|
type: VARCHAR
|
|
size: 255
|
|
vat_number:
|
|
type: VARCHAR
|
|
size: 255
|
|
crypt:
|
|
type: INTEGER
|
|
default: 0
|
|
st_invoice_currency:
|
|
_attributes:
|
|
phpName: InvoiceCurrency
|
|
created_at:
|
|
type: timestamp
|
|
updated_at:
|
|
type: timestamp
|
|
id:
|
|
type: INTEGER
|
|
primaryKey: true
|
|
required: true
|
|
autoIncrement: true
|
|
name:
|
|
type: VARCHAR
|
|
size: 255
|
|
exchange:
|
|
type: FLOAT
|
|
shortcut:
|
|
type: VARCHAR
|
|
size: 20
|
|
front_symbol:
|
|
type: VARCHAR
|
|
size: 20
|
|
back_symbol:
|
|
type: VARCHAR
|
|
size: 20
|