• Home
• io.github.modelsvgu
• ocl2psql
• 1.0.0
• source code
• staff.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

genSQL.staff.sql Maven / Gradle / Ivy

DROP DATABASE IF EXISTS stafftestdb;
CREATE DATABASE stafftestdb;
USE stafftestdb;
CREATE TABLE Staff (Staff_id INT (11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR (100), age INT (11), salary INT (11));
CREATE TABLE Employment (employer INT (11), employees INT (11));
ALTER TABLE Employment ADD FOREIGN KEY (employer) REFERENCES Staff (Staff_id), ADD FOREIGN KEY (employees) REFERENCES Staff (Staff_id);