EN

Tables (10)

customer

  • id — INTEGER — Primary key
  • user_id — INTEGER — Foreign key → users.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
  • id (user_id) — INTEGER — Foreign key → users.id — NOT NULL
  • address — VARCHAR(45)
  • address_detail — VARCHAR(50)
  • cellphone — VARCHAR(45)
  • comment — VARCHAR(45)
  • createAt — DATETIME
  • date — DATETIME
  • postcode — VARCHAR(50)
  • price — INTEGER
  • received — INTEGER
  • sales — INTEGER
  • shipped — INTEGER
  • shippingDate — DATETIME
  • state — ENUM('order','shipping','complete')
  • telephone — VARCHAR(45)

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
  • user_id — INTEGER — Foreign key → users.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
  • user_id — INTEGER — Foreign key → users.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
  • shippingDate — DATE
  • state — TINYINT UNSIGNED
  • tax — TINYINT
  • weight — INTEGER UNSIGNED
  • weight_unit — VARCHAR(10)
  • shippingEndDate — DATE

productFamily

  • 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
  • changeDate — DATETIME
  • date_manufacture — DATETIME
  • expiration — DATETIME
  • initial_quantity — INTEGER
  • memo — VARCHAR(50)
  • name — VARCHAR(45)
  • quantity — INTEGER
  • type — ENUM('상품매입','외주생산','자가생산')

users

  • 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)
  • email — VARCHAR(45)
  • expiration — DATETIME
  • name — VARCHAR(50)
  • password — VARCHAR(100)
  • phone — VARCHAR(50)
  • postcode — VARCHAR(50)
  • role — TINYINT
  • salt — VARCHAR(100)