corp-db.txt

group: corporation example
description[[
bla blubb
]]

DEPT = {
DEPTNO:number, DNAME:string, LOC:string
10, 'ACCOUNTING', 'NEY YORK'
20, 'RESEARCH', 'DALLAS'
30, 'SALES', 'CHICAGO'
40, 'OPERATIONS', 'BOSTON'
}

EMP = {
EMPNO:number, ENAME:string, JOB:string, MGR:number, HIREDATE:date, SAL:number, COMM:number, DEPTNO:number
7369, 'SMITH' , 'CLERK'    , 7902, 1980-12-17,  800, NULL, 20
7499, 'ALLEN' , 'SALESMAN' , 7698, 1981-02-20, 1600, 300,  30
7521, 'WARD'  , 'SALESMAN' , 7698, 1981-02-22, 1250, 500,  20
7566, 'JONES' , 'MANAGER'  , 7839, 1981-04-02, 2975, NULL, 20
7654, 'MARTIN', 'SALESMAN' , 7698, 1981-09-28, 1250, 1400, 20
7698, 'BLAKE' , 'MANAGER'  , 7839, 1981-05-01, 2850, NULL, 20
7782, 'CLARK' , 'MANAGER'  , 7839, 1981-06-09, 2450, NULL, 20
7788, 'SCOTT' , 'ANALYST'  , 7566, 1982-12-09, 3000, NULL, 20
7839, 'KING'  , 'PRESIDENT', NULL, 1981-11-17, 5000, NULL, 20
7844, 'TURNER', 'SALESMAN' , 7698, 1981-09-09, 1500, 0 ,   20
7876, 'ADAMS' , 'CLERK'    , 7788, 1983-01-12, 1100, NULL, 20
7900, 'JAMES' , 'CLERK'    , 7698, 1981-12-03,  950, NULL, 20
7902, 'FORD'  , 'ANALYST'  , 7566, 1981-12-03, 3000, NULL, 20
7934, 'MILLER', 'CLERK'    , 7782, 1982-01-23, 1300, NULL, 20
}