SQL and tables about the processes used in the project

SELECT * FROM Flow_main

Seqcode full_name short_name Flow_desc create_time update_time

1 coursepackflow CP Course package Online maintenance 2013-01-06 15:23:50 (NULL)
2 requirementgrabcourse RGC Elective course 2013-01-06 15:23:50 (NULL)
CourseLibFlow1 CLF Course Library Management 2013-01-06 15:23:50 (NULL)
Requirementexpertcourse REC Elective course 2013-01-08 16:30:16 (NULL)
Newcourselibflow NCLF Course Library Management 2013-06-21 10:43:03 (NULL)
Coursedevflow CDF Course Development Full Process Management 2013-10-23 00:00:00 (NULL)

SELECT * FROM Flow_config

Seqcode main_seqcode current_step next_step current_rolename next_rolename step_desc SMS_FLAG OPINION_FLAG SCOPE AUDIT_K IND DURATION FORM

1 1 1 2 0 system administrator two level training administrator to two level training Administrator 0 0 1 3 2.. /courselib/coursepack/plandepttwoadmin.do?action=init
2 1 2 4 12 level training manager two training supervisor submitted to level two training supervisor 0 0 2 2 2.. /courselib/coursepack/plandepttwomanager.do?action=init
6 1 4 2 12 level training supervisor Two level training admin return to level two training admin 0 1 2 2 2. /courselib/coursepack/plandepttwoadmin.do?action=init
5 1 4 5 12 Level Training Supervisor Course Administrator Course account Manager approval 0 0 1 3 2.. /courselib/coursepack/plancoursemanager.do?action=init
7 1 6 99 0 system administrator (NULL) end audit 0 0 1 2 2 (NULL)
9 2 1 2 0 course manager trainees are issued to students to take lessons 0 0 1 3 5. /plan/year_requirement/studentgrab.do?action=init
10 2 2 3 0 Student Course Administrator submits to course Administrator 0 0 1 1 2.. /plan/year_requirement/admingrab.do?action=init
11 2 3 99 0 Course Administrator (NULL) end grab Lesson 0 0 1 1 0 (NULL)

Flowoid missionlistoid flowflag useroid missionstate missionlevel missiondate missiontype UPUSEROID

154 22029 CDF 0 0 3 2014-04-09 0 27005638 1 2 student (NULL) course Administrator 1 (NULL) (NULL) 10: /course/coursedev/coursedevapplicantaction.do?action=init Yu Lingyan 27040000 27041000 2 2014 course development Full process management 0 (NULL) 1 (NULL) (NULL) )
154 22030 CDF 27003145 0 3 2014-04-09 0 27000026 1 33 level training supervisor (NULL) Learner 2 (NULL) 22029 2. /course/coursedev/devdeptthreemanager.do?action=init Chen Weihua 27010000 (NULL) 2 2014 course Development Full process management 0 (NULL) 3 (NULL) (NULL)
154 22031 CDF 27000029 0 3 2014-04-09 0 27003145 1 42 level training Administrator (NULL) three level training Supervisor 3 (NULL) 22030 2. /course/coursedev/devdepttwoadministrator.do?action=init Wang Sujun 27010000 (NULL) 2 2014 course Development Full process management 0 (NULL) 2 (NULL) (NULL)
154 22032 CDF 27003108 0 3 2014-04-09 0 27000029 1 52 level training supervisor (NULL) two level training Administrator 4 (NULL) 22031 2: /course/coursedev/devdepttwomanager.do?action=init Lu Wie 27010000 (NULL) 2 2014 course Development Full process management 0 (NULL) 2 (NULL) (NULL)
154 22033 CDF 0 0 3 2014-04-09 0 27003108 1 6 course administrator (NULL) two-level training supervisor 5 (NULL) 22032 2. /course/coursedev/devdeptcoursemanager.do?action=init Shanyu light 27010000 (NULL) 4 2014 course Development Full process management 0 (NULL) 1 (NULL) (NULL)

CREATE TABLE
Missionlist
(
Flowoid INTEGER,
Missionlistoid INTEGER not NULL,
Flowflag VARCHAR (50),
Useroid VARCHAR (20),
Missionstate INTEGER,
Missionlevel INTEGER,
Missiondate DATE,
Missiontype INTEGER,
Upuseroid VARCHAR (20),
Sparenum INTEGER,
Flownum INTEGER,
Userroleoid VARCHAR (22),
Openflag INTEGER,
Upuserrole VARCHAR (22),
Upflownum INTEGER,
Isback INTEGER,
Backmisoid INTEGER,
Days_num INTEGER,
Usepageurl VARCHAR (600),
Uppername VARCHAR (80),
UPPERUNIT2 VARCHAR (60),
UPPERUNIT3 VARCHAR (60),
Coalition_flag VARCHAR (1),
TOPIC VARCHAR (800),
Display_flag VARCHAR (1),
Unite_mloid INTEGER,
Pepkind VARCHAR (1),
Time_limit DATE,
Obj_units VARCHAR (2000),
CONSTRAINT CC1229658375562 PRIMARY KEY (missionlistoid)
);

CREATE TABLE
Roleinfo
(
Seqcode INTEGER not NULL,
Role_name VARCHAR (50),
Role_explain VARCHAR (1000),
Avi_flag VARCHAR (1),
Create_time DATE,
Del_time DATE,
Popedom_seqcode VARCHAR (800),
CONSTRAINT CC1228204990515 PRIMARY KEY (Seqcode)
);

SELECT * FROM Roleinfo

2 Resource Administrator Resource Administrator 1 2008-12-18 (NULL) (NULL)
Level 42 training Supervisor Level Two training Supervisor 1 2008-12-18 (NULL) (NULL)
5 Student Trainees 1 2008-12-18 (NULL) (NULL)
Level 62 Training Administrator Level Two training Administrator 1 2008-12-18 (NULL) (NULL)
1 Course Administrator Course Administrator 1 2008-12-18 (NULL)
Level 33 training Supervisor Level Three training Supervisor 1 2008-12-18 (NULL) (NULL)
7 system Administrator system Administrator 1 (NULL) (NULL) (NULL)
17 High Value Training Management HR High value 1 2009-04-20 (NULL) (NULL)
38 e-Library Administrator 1 2009-06-30 (NULL) (NULL)
Level 391 Manager Company First level manager 1 2009-08-03 (NULL) (NULL)
40 Department Data Administrator Department Data Administrator 1 2009-09-24 (NULL) (NULL)
41 Test Manager Department Test Management 1 2010-01-26 (NULL) (NULL)
42 Cell Phone Learning Management 1 2013-01-17 (NULL) (NULL)
43 Business Experts 1 2014-03-28 (NULL) (NULL)

SQL and tables about the processes used in the project