douzone_final_0228
Tables (11)
t_auth_emp
- auth_emp_seq — int(11) — Primary key — NOT NULL
- auth_seq — int(10) — Foreign key → t_auth_main.auth_seq — NOT NULL
- emp_seq — int(10) — Foreign key → t_emp_main.emp_seq — NOT NULL
- created_at — timestamp
t_auth_main
- auth_seq — int(10) — Primary key — NOT NULL
- comp_seq — int(11) — Foreign key → t_company.comp_seq — NOT NULL
- auth_name — varchar(255) — NOT NULL
- auth_detail — varchar(255)
- created_at — timestamp
t_auth_menu
- auth_menu_seq — int(11) — Primary key — NOT NULL
- auth_seq — int(10) — Foreign key → t_auth_main.auth_seq — NOT NULL
- menu_no — int(11) — Foreign key → t_menu.menu_no — NOT NULL
- created_at — timestamp
t_biz
- biz_seq — int(10) — Primary key — NOT NULL
- comp_seq — int(11) — Foreign key → t_company.comp_seq
- biz_name — varchar(50)
- biz_code — varchar(50)
- created_at — timestamp
t_company
- comp_seq — int(10) — Primary key — NOT NULL
- comp_name — varchar(255)
- comp_yn — varchar(255)
- comp_short — varchar(255)
- comp_code — varchar(255)
- comp_number — varchar(255)
- comp_industry — varchar(255)
- comp_type — varchar(255)
- comp_ceo — varchar(255)
- comp_address — varchar(255)
- comp_email — varchar(255)
- comp_fax — varchar(255)
- comp_lang — varchar(255)
- comp_reg_num — varchar(255)
- comp_cor_num — varchar(255)
- comp_foreign — varchar(255)
- comp_domain — varchar(255)
- created_at — timestamp
t_dept
- dept_seq — int(10) — Primary key — NOT NULL
- comp_seq — int(10) — Foreign key → t_company.comp_seq — NOT NULL
- biz_seq — int(10) — Foreign key → t_biz.biz_seq — NOT NULL
- dept_name — varchar(50) — NOT NULL
- dept_code — varchar(50) — NOT NULL
- dept_parent — int(11) — Foreign key → t_dept.dept_seq
- dept_address — varchar(50) — NOT NULL
- dept_number — varchar(50) — NOT NULL
- created_at — timestamp
t_emp_comp
- emp_comp_seq — int(10) — Primary key — NOT NULL
- emp_seq — int(10) — Foreign key → t_emp_main.emp_seq
- comp_seq — int(11) — Foreign key → t_company.comp_seq
- biz_seq — int(11) — Foreign key → t_biz.biz_seq
- dept_seq — int(11) — Foreign key → t_dept.dept_seq
- created_at — timestamp
t_emp_dept
- emp_dept_seq — int(10) — Primary key — NOT NULL
- emp_seq — int(10) — Foreign key → t_emp_main.emp_seq
- comp_seq — int(10) — Foreign key → t_company.comp_seq
- biz_seq — int(10) — Foreign key → t_biz.biz_seq
- dept_seq — int(10) — Foreign key → t_dept.dept_seq
- created_at — timestamp
t_emp_main
- emp_seq — int(10) — Primary key — NOT NULL
- emp_id — varchar(255)
- emp_code — varchar(50)
- emp_pwd — varchar(255)
- emp_name — varchar(255)
- emp_phone — varchar(255)
- emp_sex — varchar(255)
- emp_address — varchar(255)
- emp_email — varchar(255)
- emp_joindate — timestamp
- emp_exitdate — timestamp
- created_at — timestamp
t_emp_rank
- emp_rank_seq — int(11) — Primary key — NOT NULL
- emp_seq — int(10) — Foreign key → t_emp_main.emp_seq — NOT NULL
- comp_seq — int(10) — Foreign key → t_company.comp_seq
- dept_seq — int(10) — Foreign key → t_dept.dept_seq
- emp_roo — varchar(255)
- emp_jobgrade — varchar(255)
- created_at — timestamp
t_menu
- menu_no — int(10) — Primary key — NOT NULL
- menu_name — varchar(50) — NOT NULL
- menu_role — int(11) — NOT NULL
- menu_parent — int(11) — NOT NULL
- created_at — timestamp