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 — 추후 예정