DBMS online

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')