EN_update_plan
Tables (11)
company
- id — INTEGER — Primary key — NOT NULL
- accountName — VARCHAR(45)
- accountNumber — VARCHAR(45)
- address — VARCHAR(100)
- address_detail — VARCHAR(100)
- created_date — DATETIME
- crNumber — VARCHAR(45)
- expiration — DATETIME
- name — VARCHAR(50)
- password — VARCHAR(100)
- phone — VARCHAR(50)
- postcode — VARCHAR(50)
- salt — VARCHAR(100)
- test — TINYINT
customer
- id — INTEGER — Primary key
- company_id — INTEGER — Foreign key → company.id — NOT NULL
- address — VARCHAR(150) — NOT NULL
- address_detail — VARCHAR(150)
- cellphone — VARCHAR(45)
- delegate — VARCHAR(45)
- crNumber — VARCHAR(50)
- name — VARCHAR(255)
- postcode — VARCHAR(150)
- set — TINYINT
- telephone — VARCHAR(45)
employee
- id — INTEGER — Primary key — NOT NULL
- description — VARCHAR(45)
- keyword — VARCHAR(45)
- name — VARCHAR(255)
- set — TINYINT
- transfer — VARCHAR(45)
familyCategory
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50)
order
- id — INTEGER — Primary key — NOT NULL
- customer_id — INTEGER — Foreign key → customer.id
- company_id — INTEGER — Foreign key → company.id — NOT NULL
- address — VARCHAR(45)
- address_detail — VARCHAR(50)
- cellphone — VARCHAR(45)
- comment — VARCHAR(45)
- create_at — DATETIME
- date — DATETIME
- postcode — VARCHAR(50)
- price — INTEGER
- received — INTEGER
- sales — INTEGER
- shipped — INTEGER
- shipping_start — DATETIME
- state — ENUM('order','shipping','complete')
- telephone — VARCHAR(45)
- shipping_end — DATETIME
order_product
- id — INTEGER — Primary key — NOT NULL
- order_id — INTEGER — Foreign key → order.id — NOT NULL
- product_id — INTEGER — Foreign key → product.id — NOT NULL
- plant_id — INTEGER — Foreign key → plant.id — NOT NULL
- stock_id — INTEGER — Foreign key → stock.id — NOT NULL
- price — INTEGER
- quantity — INTEGER
- refund — TINYINT
- tax — TINYINT
plant
- id — INTEGER — Primary key — NOT NULL
- company_id — INTEGER — Foreign key → company.id — NOT NULL
- additional_company — VARCHAR(45)
- division — VARCHAR(45)
- name — VARCHAR(255)
- outsourcing_company — VARCHAR(45)
- set — TINYINT
product
- id — INTEGER — Primary key — NOT NULL
- company_id — INTEGER — Foreign key → company.id — NOT NULL
- additional — VARCHAR(45)
- amount — INTEGER
- barcode — VARCHAR(45)
- date — DATETIME
- detail_file — VARCHAR(300)
- discount_price — VARCHAR(45)
- family — INTEGER
- file_name — VARCHAR(45)
- gap — VARCHAR(45)
- grade — VARCHAR(45)
- mallVisible — TINYINT UNSIGNED
- name — VARCHAR(255)
- price_receiving — INTEGER UNSIGNED
- price_shipping — INTEGER UNSIGNED
- safety_stock — INTEGER
- set — TINYINT
- shipping_start_date — DATE
- shipping_end_date — DATE
- state — TINYINT UNSIGNED
- tax — TINYINT
- weight — INTEGER UNSIGNED
- weight_unit — VARCHAR(10)
product_family
- id — INTEGER — Primary key — NOT NULL
- category — INTEGER — Foreign key → familyCategory.id — NOT NULL
- name — VARCHAR(50)
stock
- id — INTEGER — Primary key — NOT NULL
- product_id — INTEGER — Foreign key → product.id — NOT NULL
- plant_id — INTEGER — Foreign key → plant.id — NOT NULL
- change_date_quantity — DATETIME
- date_manufacture — DATETIME
- expiration — DATETIME
- initial_quantity — INTEGER
- memo — VARCHAR(50)
- name — VARCHAR(45)
- quantity — INTEGER
- type — ENUM('상품매입','외주생산','자가생산')
- state — TINYINT
- change_date_state — DATETIME
users
- id — INTEGER — Primary key — NOT NULL
- company_id — INTEGER — Foreign key → company.id — NOT NULL
- password — VARCHAR(100)
- role — TINYINT
- Field
- phone — VARCHAR(50)
- crNumber — VARCHAR(45)
- created_date — DATETIME