Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE customer(
- ssn VARCHAR(10) NOT NULL PRIMARY KEY,
- firstname VARCHAR(10),
- lastname VARCHAR(10),
- email VARCHAR(20) NOT NULL UNIQUE,
- phonenumber VARCHAR(11) NOT NULL UNIQUE
- );
- INSERT INTO `customer`(`ssn`, `firstname`, `lastname`, `email`, `phonenumber`) VALUES ("161036","apel","Mahmud","017100000","apl.mhd@gmail.com")
- CREATE TABLE invoice(
- ordernumber INT NOT NULL PRIMARY KEY,
- price FLOAT,
- quantity INT DEFAULT 1,
- ssn VARCHAR(20),
- orderdate DATE,
- CONSTRAINT fk_const FOREIGN KEY (ssn) REFERENCES customer(ssn)
- CHECK (prcie >=500)
- );
- INSERT INTO `invoice`(`ordernumber`, `price`, `quantity`, `ssn`) VALUES (1,500,10, '161036')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement