IES System
Tables (44)
bank_accounts (Untitled27)
bill_to_addresses (Untitled14)
- id (Key) — Primary key — NOT NULL
- client_id (Key2) — Primary key — NOT NULL
- Key3 — Primary key — NOT NULL
- street1 (Field)
- street2 (Field2)
- street3 (Field3)
- city (Field4)
- province (Field5)
- country (Field6)
- zipcode (Field7)
branches
- Key (id) — Primary key — NOT NULL
- Field (name) — string — NOT NULL
- Field2 (display_name) — string — NOT NULL
- Field3 (address) — string — NOT NULL
- Field4 (zipcode) — string — NOT NULL
- Field5 (phone) — string
- Field6 (fax) — string
- Field7 (vat_reg_number) — string
- Field8 (email) — string
- Field (code) — string — NOT NULL
- Field (description) — text
- Field (is_active) — boolean — NOT NULL
client_employees (Untitled12)
comments (banks)
- Key (id) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
companies (Untitled4)
- id (Key) — Primary key — NOT NULL
company_ship_addresses (Untitled6)
- id (Key) — Primary key — NOT NULL
- code (Field)
invoice_client_reminders (Untitled29)
invoice_lines (Untitled18)
invoice_pdfs (Untitled31)
invoice_reminders (Untitled28)
invoice_statuses (Untitled20)
notification_reads (CopyOfusers)
- id (Key) — int — Primary key — comment
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
notifications (CopyOfusers2)
- id (Key) — int — Primary key — comment
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
payment_methods (Untitled10)
payment_statuses (Untitled7)
purchase_order_lines (Untitled22)
purchase_order_statuses (Untitled23)
quote_extra_fields (Untitled36)
quote_statuses (Untitled19)
quotes (CopyOfUntitled32)
- Key2 — Primary key — NOT NULL
- id (Key) — int — Foreign key → works.id — comment
- sale_order_id (Field) — int — comment
- revision (Field2)
- effective_from (Field3)
- effective_to (Field4)
sale_order_lines (Untitled8)
sale_order_statuses (Untitled21)
sale_orders (CopyOfusers3)
- id (Key) — int — Primary key — comment
- is_active (Field)
- Field2
- Field3
- Field4
- Field5
- Field6
ship_to_addresses (Untitled13)
shipping_methods (Untitled9)
supplier_employees (Untitled34)
suppliers_bank_account (Untitled)
users
- id — int — Primary key — NOT NULL
- is_active (name) — string — NOT NULL
- name (last_name) — string — NOT NULL
- last_name (kor_name) — string — NOT NULL
- korean_name (title) — string — NOT NULL
- Field5 (is_active) — boolean — NOT NULL
- Field6 (email) — string — NOT NULL
- Field7 (email_verified_at) — timestamp
- Field8 (branch_id) — int — NOT NULL
- Field9 (department_id) — int — NOT NULL
- Field10 (position_id) — int — NOT NULL
- Field11 (mobile) — string — NOT NULL
- Field12 (phone) — string
- Field (uuid) — string
- Field2 (remeber_token) — string
- Field3 (password) — string — NOT NULL
- Field4 (created_at) — timestamp
- Field5 (updated_at) — timestamp
works (CopyOfusers4)
- id (Key) — int — Primary key — comment
- is_active (Field)
- Field2
- Field3
- Field4
- Field5
- Field6