11

Tables (24)

Untitled (projects)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string — NOT NULL
  • Field2 (display_name) — string
  • Field3 (description) — text
  • Field4 (code) — string — NOT NULL

Untitled

    Untitled (purchase_type)

    • Key2 (id) — int — Primary key — NOT NULL
    • Field2 (name) — string — NOT NULL
    • Field (display_name) — string — NOT NULL
    • Field3 (description) — text

    Untitled (quotation_versions)

    • Key (id) — int — Primary key — NOT NULL
    • Field (version) — int — NOT NULL
    • Field2 (user_id) — int — NOT NULL
    • Field (file_id) — int — NOT NULL — 릴레이션

    Untitled (banks)

    • Key (id) — int — Primary key — NOT NULL
    • Field (name) — string — NOT NULL
    • Field2 (display_name) — string
    • Field3 (account_number) — string — NOT NULL
    • Field (swift_code) — string
    • Field2 (bank_address) — string
    • Field4 (description) — text

    Untitled (jobs)

      Untitled (workers)

        Untitled (shipping_status)

          Untitled (shippings)

            Untitled (invoices)

              Untitled (orders)

                Untitled (items)

                • Key (id) — int — Primary key — NOT NULL
                • Field (display_number)
                • Field (name) — string — NOT NULL
                • Field4 (size) — string
                • Field5 (bidding_price) — decimal(10,2) — NOT NULL
                • Field (purchasing_price) — decimal(10,2)
                • Field6 (quantity) — decimal(10,2) — NOT NULL
                • Field10 (unit) — string — NOT NULL
                • Field11 (bidding_currency) — string — NOT NULL
                • Field12 (purchasing_currency) — string — NOT NULL
                • Field13 (purchasing_type) — string
                • Field14 (verdor_id) — int
                • Field15 (quotation_id) — int — NOT NULL
                • Field9 (shipping_id) — int — NOT NULL

                Untitled (quotation_extra_fileds)

                • Key (id) — int — Primary key — NOT NULL
                • Field (title) — string — NOT NULL
                • Field2 (content) — text — NOT NULL
                • Field3 (type) — string — NOT NULL — 이건 뭐지?
                • Field4 (quotation_id) — int — NOT NULL

                Untitled (quotations)

                • Key (id) — int — Primary key — NOT NULL
                • Field (number) — string — NOT NULL
                • Field11 (version) — int — NOT NULL
                • Field (type) — string — NOT NULL — N or E
                • Field2 (status) — string
                • Field3 (por_no) — string
                • Field4 (sr_no) — string
                • Field5 (issued_date) — string
                • Field12 (approved) — boolean — NOT NULL
                • Field13 (currency) — string — NOT NULL
                • Field6 (title) — string
                • Field7 (remark) — text
                • Field8 (default_setting_id) — int — NOT NULL
                • Field (user_id) — int — NOT NULL
                • Field14 (ngoui_id) — int — NOT NULL
                • Field (originator_id) — int — NOT NULL
                • Field15 (company_id) — int — NOT NULL
                • Field2 (project_id) — int — NOT NULL
                • Field16 (category_id) — int — NOT NULL
                • Field (remarks) — text
                • Field2 (notice) — text

                Untitled (categories)

                • Key — Primary key — NOT NULL
                • Field
                • Field2
                • Field3
                • Field4
                • Field5
                • Field6
                • Field7

                Untitled (ngouis)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string
                • Field2 (title) — string
                • Field3 (department) — string
                • Field4 (position) — string
                • Field5 (email) — string
                • Field6 (description) — text
                • Field7 (phone) — string
                • Field9 (vendor_id) — int
                • Field8 (company_id) — int

                Untitled (verdors)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (display_name) — string
                • Field3 (address) — string
                • Field4 (phone) — string
                • Field5 (fax) — string
                • Field6 (url) — string
                • Field (email) — string
                • Field2 (vat_reg_no) — string
                • Field3 (description) — string

                Untitled (currencies)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (display_name) — string
                • Field3 (description) — text

                Untitled (units)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (display_name) — string
                • Field3 (description) — text

                Untitled (default_settings)

                • Key (id) — int — Primary key — NOT NULL
                • Field (display_name) — string — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (address) — string — NOT NULL
                • Field3 (zipcode) — string — NOT NULL
                • Field4 (phone) — string — NOT NULL
                • Field5 (fax) — string — NOT NULL
                • Field6 (vat_reg_no) — string — NOT NULL
                • Field7 (email) — string — NOT NULL

                Untitled (item_categories)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (display_name) — string
                • Field3 (description) — text

                Untitled (companies)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (display_name) — string — NOT NULL
                • Field3 (address) — string
                • Field4 (phone) — string
                • Field5 (zipcode) — string
                • Field6 (url) — string
                • Field7 (description) — text
                • Field8 (code) — string — NOT NULL
                • Field9
                • Field10
                • Field11

                Untitled2 (quotation_types)

                • Key (id) — int — Primary key — NOT NULL
                • Field (name) — string — NOT NULL
                • Field2 (display_name) — string

                Users table (users)

                • User id (user_id) — int — Primary key — NOT NULL
                • User name (name) — string — NOT NULL
                • Sex title (title) — string — NOT NULL
                • Email Address (email) — string — NOT NULL — unique value
                • Field3 (password) — string — NOT NULL
                • Field4 (active) — boolean — NOT NULL
                • Field5 (position) — string — NOT NULL
                • Field6 (phone) — string
                • Field7 (branch_id) — int — NOT NULL — 추후 예정
                • Field8 (department_id) — int — NOT NULL — 추후 예정
                • Field9 (position_id) — int — NOT NULL — 추후 예정