The Mon

Tables (15)

Bin (bin)

  • Bin (bin) — Varchar(10) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • F Kind (fkind) — Varchar(10)
  • Line (line) — Varchar(10)
  • S Name (sname) — Varchar(50)
  • Flag (flag) — Varchar(10)
  • I Code (icode) — Varchar(20)
  • I Name (iname) — Varchar(50)
  • EQ Bin (eqbin) — Varchar(5)
  • Fall (fall) — Num(10, 2)
  • Deviation (deviation) — Num(10, 2)
  • Capa (capa) — Num(10, 2)
  • Pos (pos) — Num(10, 2)
  • Use YN (use_yn) — Varchar(10)
  • Process Type (process_type) — Varchar(20)
  • Unit G (unit_g) — Num(10, 2)
  • Put In Mid (put_in_mid) — Num(10, 2)
  • Put In Small (put_in_small) — Num(10, 2)
  • Jogging On (jogging_on) — Num(10, 2)
  • Jogging Off (jogging_off) — Num(10, 2)
  • Auto Fall (auto_fall) — Num(10, 2)
  • Put In Speed Big (put_in_speed_big) — Num(10, 2)
  • Put In Speed Mid (put_in_speed_mid) — Num(10, 2)
  • put In Speed Small (put_in_speed_small) — Num(10, 2)
  • BIgo (bigo) — Varchar(50)
  • Ingred Prod Type (ingred_prod_type) — Varchar(20)
  • Stock Now (stock_now) — Num(10, 2)
  • Stock In (stock_in) — Num(10, 2)
  • Stock Out (stock_out) — Num(10, 2)
  • Stock Adjust (stock_adjust) — Num(10, 2)
  • Stock Before (stock_before) — Num(10, 2)
  • Worker (worker) — Varchar(20)
  • Reg DT (reg_datetime) — Varchar(20)
  • Mod DT (mod_datetime) — Varchar(20)

Blk Sched (blk_sched)

  • Code (code) — Varchar(20) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Flag (flag) — Varchar(20)
  • CAR (car) — Varchar(20)
  • Cust Code (ccode) — Varchar(20)
  • Cust Name (cname) — Varchar(20)
  • Fcode (fcode) — Varchar(20)
  • Fname (fname) — Varchar(50)
  • Scale (scale) — Varchar(5)
  • Bin (bin) — Varchar(5)
  • Batch Size (batch_size) — Int(5)
  • Preset Batch (preset_batch) — Int(3)
  • Actual Batch (actual_batch) — Int(3)
  • Preset Val (preset_val) — Num(10, 2)
  • Actual Val (actual_val) — Num(10, 2)
  • Start Time (stime) — Varchar(10)
  • End Time (etime) — Varchar(10)
  • Confirm State (confirm_state) — Varchar(10)
  • Ramin YN (remain_yn) — Varchar(10)
  • Bigo (bigo) — Varchar(100)
  • Job Date (job_date) — Varchar(20)
  • Arrive Data (arrive_date) — Varchar(20)
  • Mov No (mov_no) — Varchar(20)
  • Mov Sq (mov_sq) — Int(3)
  • Worker (worker) — Varchar(20)
  • Reg DT (reg_datetime) — Varchar(20)
  • Mod DT (mod_datetime) — Varchar(20)

Blk Sched C (blk_sched_c)

  • CDate (cdate) — Varchar(10) — Primary key — NOT NULL
  • Code (code) — Varchar(20) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Flag (flag) — Varchar(20)
  • CAR (car) — Varchar(20)
  • Cust Code (ccode) — Varchar(20)
  • Cust Name (cname) — Varchar(20)
  • Fcode (fcode) — Varchar(20)
  • Fname (fname) — Varchar(50)
  • Scale (scale) — Varchar(5)
  • Bin (bin) — Varchar(5)
  • Batch Size (batch_size) — Int(5)
  • Preset Batch (preset_batch) — Int(3)
  • Actual Batch (actual_batch) — Int(3)
  • Preset Val (preset_val) — Num(10, 2)
  • Actual Val (actual_val) — Num(10, 2)
  • Start Time (stime) — Varchar(10)
  • End Time (etime) — Varchar(10)
  • Confirm State (confirm_state) — Varchar(10)
  • Ramin YN (remain_yn) — Varchar(10)
  • Bigo (bigo) — Varchar(100)
  • Job Date (job_date) — Varchar(20)
  • Arrive Data (arrive_date) — Varchar(20)
  • Mov No (mov_no) — Varchar(20)
  • Mov Sq (mov_sq) — Int(3)
  • Worker (worker) — Varchar(20)
  • Reg DT (reg_datetime) — Varchar(20)
  • Mod DT (mod_datetime) — Varchar(20)

Dos Sched (dos_sched)

  • Code (code) — Varchar(20) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Flag (flag) — Varchar(20)
  • Fcode (fcode) — Varchar(20)
  • Fname (fname) — Varchar(50)
  • For Code (for_code) — Varchar(20)
  • Preset Batch (preset_batch) — Int(3)
  • Actual Batch (actual_batch) — Int(3)
  • Batch Size (batch_size) — Int(5)
  • Conv1 (conv1) — Varchar(10)
  • Conv2 (conv2) — Varchar(10)
  • Conv3 (conv3) — Varchar(10)
  • Conv4 (conv4) — Varchar(10)
  • Preset Val (preset_val) — Num(10, 2)
  • Actual Val (actual_val) — Num(10, 2)
  • Start Time (stime) — Varchar(10)
  • End Time (etime) — Varchar(10)
  • Job Date (job_date) — Varchar(20)
  • Worker (worker) — Varchar(20)
  • Reg DT (reg_datetime) — Varchar(20)
  • Mod DT (mod_datetime) — Varchar(20)

Dos Sched C (dos_sched_c)

  • CDate (cdate) — Varchar(10) — Primary key — NOT NULL
  • Code (code) — Varchar(20) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Flag (flag) — Varchar(20)
  • Fcode (fcode) — Varchar(20)
  • Fname (fname) — Varchar(50)
  • For Code (for_code) — Varchar(20)
  • Preset Batch (preset_batch) — Int(3)
  • Actual Batch (actual_batch) — Int(3)
  • Batch Size (batch_size) — Int(5)
  • Conv1 (conv1) — Varchar(10)
  • Conv2 (conv2) — Varchar(10)
  • Conv3 (conv3) — Varchar(10)
  • Conv4 (conv4) — Varchar(10)
  • Preset Val (preset_val) — Num(10, 2)
  • Actual Val (actual_val) — Num(10, 2)
  • Start Time (stime) — Varchar(10)
  • End Time (etime) — Varchar(10)
  • Job Date (job_date) — Varchar(20)
  • Worker (worker) — Varchar(20)
  • Reg DT (reg_datetime) — Varchar(20)
  • Mod DT (mod_datetime) — Varchar(20)

Group Process Type (group_process_type)

  • Line (line) — Varchar(10) — Primary key
  • Hogi (hogi) — Int(3) — Primary key
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Process Type (process_type) — Varchar(20) — Foreign key → Process Type.Process Type — NOT NULL
  • Desc (desc) — Varchar(100)

Ingred (ingred)

  • Code (code) — Varchar(20) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Name (name) — Varchar(100)
  • Use YN (use_yn) — Varchar(20)
  • Ingred Type (ingred_type) — Varchar(20)
  • Bigo (bigo) — Varchar(100)

Job State (job_state)

  • Gropup ID (group_id) — Varchar(100) — Foreign key → Group Process Type.Gropup ID — NOT NULL
  • Process Type (process_type) — Varchar(20) — Foreign key → Group Process Type.Process Type — NOT NULL
  • Line (line) — Varchar(10) — Foreign key → Group Process Type.Line
  • Hogi (hogi) — Int(3) — Foreign key → Group Process Type.Hogi
  • Job State (job_state) — Varchar(20)

Process Type (process_type)

  • Process Type (process_type) — Varchar(20) — Primary key — NOT NULL
  • Process Name (process_name) — Varchar(20) — TC : 강사 ST : 학생

Prod Stock (prod_stock)

  • Type (type) — Varchar(20) — Primary key — NOT NULL
  • Unit (unit) — Int(5) — Primary key — NOT NULL
  • Prod Code (prod_code) — Varchar(20) — Foreign key → Product.Code — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → Product.Gropup ID — NOT NULL
  • Stock (stock) — Int(5)

Product (product)

  • Code (code) — Varchar(20) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Name (name) — Varchar(100)
  • Use YN (use_yn) — Varchar(20)
  • Prod Type (prod_type) — Varchar(20)
  • Packing Unit (packing_unit) — Int(3)
  • Bigo (bigo) — Varchar(100)

TruckScale (truck_scale)

  • Serial (serial) — Int(10) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Car (car) — Varchar(20)
  • Type (type) — Varchar(10)
  • Flag (flag) — Varchar(10)
  • In Date (indate) — Varchar(10)
  • In Time (intime) — Varchar(10)
  • Out Date (outdate) — Varchar(10)
  • Out Time (outtime) — Varchar(10)
  • Arrive Date (arrive_date) — Varchar(10)
  • Weight In (w_in) — Int(7)
  • Weight Out (w_out) — Int(7)
  • Weight Etc (w_etc) — Int(7)
  • Weight Act (w_act) — Int(7)
  • Weight Act2 (w)act2) — Int(7)
  • Worker (worker) — Varchar(20)
  • Bigo (bigo) — Varchar(100)
  • Cust Code (cust_code) — Varchar(20)
  • Cust Name (cust_name) — Varchar(100)
  • Cust Code2 (cust2_code) — Varchar(20)
  • Cust Name2 (cust2_name) — Varchar(100)
  • Prod Code (prod_code) — Varchar(20)
  • Prod Name (prod_name) — Varchar(100)

User (user)

  • User ID (user_id) — Varchar(50) — Primary key — NOT NULL
  • Gropup ID (group_id) — Varchar(100) — Foreign key → User Group.Gropup ID — NOT NULL
  • Password (password) — Varchar(20)
  • Name (name) — Varchar(100)
  • Email (email) — Varchar(100)
  • Phone (phone) — Varchar(20)
  • Nick Name (nick_name) — Varchar(100)
  • Login Type (login_type) — Varchar(20)
  • Login State (login_state) — Varchar(20)
  • Last Login DT (last_login_datetime) — Datetime
  • Last Logout DT (last_logout_datetime) — Datetime
  • Index (user_index) — Bigint(20)
  • Refresh Token (refresh_token) — Varchar(1024)
  • Signup DateTime (signup_datetime) — Datetime
  • State (state) — Varchar(20)
  • Temp Password (temp_password) — Varchar(20)
  • User Type (user_type) — Varchar(50) — Foreign key → User Type.User Type — NOT NULL

User Group (user_group)

  • Gropup ID (group_id) — Varchar(100) — Primary key — NOT NULL
  • Group Name (group_name) — Varchar(100)
  • Group Logo (group_logo) — Varchar(256)

User Type (user_type)

  • User Type (user_type) — Varchar(50) — Primary key — NOT NULL
  • Desc (desc) — Varchar(100) — TC : 강사 ST : 학생