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 : 학생