IES System

Tables (44)

Untitled35

    Untitled5

      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)

          clients (Untitled11)

            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)

            departments (Untitled25)

              files (Untitled30)

                invoice_client_reminders (Untitled29)

                  invoice_lines (Untitled18)

                    invoice_pdfs (Untitled31)

                      invoice_reminders (Untitled28)

                        invoice_statuses (Untitled20)

                          invoices (Untitled3)

                            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)

                                payments (Untitled16)

                                  positions (Untitled26)

                                    purchase_order_lines (Untitled22)

                                      purchase_order_statuses (Untitled23)

                                        purchase_orders

                                        • Field

                                        quote_extra_fields (Untitled36)

                                          quote_lines (Untitled17)

                                            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

                                                  scraps (Untitled2)

                                                    ship_to_addresses (Untitled13)

                                                      shipping_methods (Untitled9)

                                                        supplier_employees (Untitled34)

                                                          suppliers (Untitled33)

                                                            suppliers_bank_account (Untitled)

                                                              taxes (currencies)

                                                                units

                                                                  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