create table employment_info
(
jiuye_type varchar(50),
employment varchar(50),
quarters varchar(50),
wage varchar(20),
property varchar(50),
industry varchar(50),
domain varchar(50),
danwei_type varchar(50),
business_entity varchar(50),
name varchar(50),
duty varchar(50),
address varchar(200),
post_code varchar(50),
tel varchar(20),
email varchar(50),
stu_ID int,
ID int identity primary key
)
create table tb_admin
(
ID int identity primary key,
log_name varchar(20),
password varchar(20),
rel_name varchar(20),
job_no varchar(20),
tel varchar(20),
emai varchar(50),
department varchar(50)
)
create table tb_article
(
id int identity primary key,
mode_name varchar(20),
sub_mode varchar(20),
publish_person varchar(20),
p_time datetime,
article_content text,
title varchar(200),
ispic varchar(4),
picurl varchar(100),
clicks int
)
create table tb_cmp
(
ID int identity primary key,
log_name varchar(50),
password varchar(20),
company_name varchar(30),
Business_no varchar(30),
industry varchar(30),
type varchar(30),
home_page varchar(80),
address varchar(100),
post_code varchar(50),
Contact_person varchar(50),
tel varchar(50),
email varchar(50),
fax varchar(12),
introduced Ntext,
remarks varchar(50),
examin varchar(50),
regist_time datetime,
setup_time datetime,
person_num varchar(20),
money varchar(20)
)
create table tb_mode
(
id int identity primary key,
name varchar(50),
f_id int
)
create table tb_Recruitment
(
ID int identity primary key,
title varchar(100),
Clicks int,
zp_info ntext,
date_time datetime,
company_ID int,
examin varchar(50)
)
create table tb_stu
(
ID int identity primary key,
log_name varchar(50),
password varchar(50),
real_name varchar(50)
)
create table tb_stuResume
(
ID int identity primary key,
stu_ID varchar(100),
gender varchar(100),
nation varchar(100),
political_affiliation varchar(100),
originPlace varchar(100),
id_card_no varchar(50),
stu_no varchar(50),
dep varchar(50),
professional varchar(50),
grade_no varchar(50),
xuezhi varchar(50),
ruxue_year datetime,
address varchar(200),
post_code varchar(50),
language_level varchar(100),
tel varchar(100),
email varchar(100),
eduExpe text,
reward text,
duty text,
experience text,
imageUrl varchar(100)
)
