Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Pro DB's project
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE DATABASE OnlineWorkFinding USE OnlineWorkFinding CREATE TABLE employer ( employerID int NOT NULL, FirstName varchar(255) NOT NULL, LastName varchar(255) NOT NULL, Address varchar(255), City varchar(255) NOT NULL, PRIMARY KEY (employerID), FOREIGN KEY (job_adID) REFERENCES job_ad(job_adID), FOREIGN KEY (jobID) REFERENCES job (jobID) ); USE OnlineWorkFinding CREATE TABLE employer ( employeeID int NOT NULL, FirstName varchar(255) NOT NULL, LastName varchar(255) NOT NULL, Address varchar(255), City varchar(255) NOT NULL, PRIMARY KEY (employeeID), ); USE OnlineWorkFinding CREATE TABLE job ( jobID int NOT NULL, jobName varchar(255) NOT NULL, Salary int, Address varchar(255), City varchar(255) NOT NULL, PRIMARY KEY (jobID), ); USE OnlineWorkFinding CREATE TABLE job_ad ( Job_adID int NOT NULL, jobName varchar(255) NOT NULL, Salary int NOT NULL, Address varchar(255) NOT NULL, City varchar(255) NOT NULL, PRIMARY KEY (Job_adID), FOREIGN KEY (jobID) REFERENCES job (jobID), );
run
|
edit
|
history
|
help
0
dbms
BRYAN_BD1
Record rows
tableB
StackOverflow_53753663
EXP 8 q2
Yan_1st_wall
tables creation
BT SQL Project
Demo