일정관리 DB 스키마

 

일정관리_1.erwin

 

DB 스키마 ver 1.0

 

CREATE TABLE MOS_company
(
	company_idx          INTEGER NOT NULL auto_increment primary key,
	com_name             VARCHAR(100) NULL default '',
	com_damdang          VARCHAR(50) NULL default '',
	com_tel              VARCHAR(20) NULL default '',
	com_mobile           VARCHAR(20) NULL default '',
	com_url              VARCHAR(150) NULL default '',
	com_logo             VARCHAR(150) NULL default ''
);





CREATE TABLE MOS_dayjob
(
	dayjob_idx           INTEGER NOT NULL  auto_increment primary key,
	subject              VARBINARY(200) NOT NULL default '',
	contents             TEXT NULL default '',
	job_part             TINYINT(2) NOT NULL default 1,
	status               TINYINT(1) NULL default 1,
	inputdate            DATETIME NULL default '0000-00-00 00:00:00',
	employee_idx         INTEGER NOT NULL,
	company_idx          INTEGER NOT NULL
);




CREATE TABLE MOS_employee
(
	employee_idx         INTEGER NOT NULL auto_increment primary key,
	name                 VARCHAR(50) NULL default '',
	mobile               VARCHAR(20) NULL default '',
	department           VARCHAR(20) NULL default ''
);





ALTER TABLE MOS_dayjob
ADD FOREIGN KEY R_1 (employee_idx) REFERENCES MOS_employee (employee_idx);



ALTER TABLE MOS_dayjob
ADD FOREIGN KEY R_2 (company_idx) REFERENCES MOS_company (company_idx);