internship
Tables (7)
class (Untitled)
- class_id — varchar(8) — Primary key — NOT NULL
- class_name — varchar(60)
- class_short — varchar(20)
intsite
- intsite_id — varchar(10) — Primary key — NOT NULL
- intzone_id — varchar(5) — Foreign key → intzone.intzone_id — NOT NULL
- name — varchar(80)
- type — varchar(20)
- street — varchar(60)
- subdistrict — varchar(30)
- district — varchar(30)
- province — varchar(30)
- postcode — varchar(10)
- phone — varchar(20)
- fax — varchar(15) — NOT NULL
- website — varchar(40)
- email — varchar(40)
- contactperson — varchar(80)
- addedby — varchar(15)
- approved — varchar(8)
- note — varchar(30)
- lastupdate — date
intstd
- intstd_id — varchar(10) — Primary key — NOT NULL
- visitby — varchar(4) — Foreign key → intvisit.visitby — NOT NULL
- status — varchar(10)
- notice — varchar(70)
- forint — varchar(4)
- semester — varchar(4)
- accyear — varchar(4)
- realyear — varchar(4)
- registered — smallint
- completed — smallint
- intsite — varchar(10)
- placed — varchar(10)
- position — varchar(40)
- orientdate — varchar(35)
- startdate — varchar(35)
- enddate — varchar(35)
- docnum — varchar(8)
- lastchange — date
intvisit
- visitby — varchar(4) — Primary key — NOT NULL
- lec_name — varchar(60)
- lec_surname — varchar(60)
intzone
- intzone_id — varchar(5) — Primary key — NOT NULL
- zone_name — varchar(60)
- cluster — varchar(40)
stream
- stream_id — varchar(10) — Primary key — NOT NULL
- stream_name — varchar(80)
students
- stdid — varchar(15) — Primary key — NOT NULL
- class_id — varchar(8) — Foreign key → class.class_id — NOT NULL
- stream_id — varchar(10) — Foreign key → stream.stream_id — NOT NULL
- firstname — varchar(20)
- lastname — varchar(20)
- nickname — varchar(15)
- title — varchar(4)
- std_status — varchar(10)
- grade — varchar(5)
- telephone — varchar(15)
- email — varchar(15)
- parent_name — varchar(15)
- parent_tel — varchar(15)
- image — varchar(30)
- lastupdate — date