kadai11.sql

create database OrderDB;
show databases;
use OrderDB;


use OrderDB;
create table OrderT(
    OrderID char(5) primary key,
    OData date not null,
    OCorpID char(4) not null
);
create table CorpT(
    CorpID char(4) primary key,
    CorpName varchar(20) not null,
    CorpAddr varchar(100)
);

create table DetailT(
    OrderID char(5),
    Item varchar(20) not null,
    Price int unsigned not null,
    Qty smallint unsigned not null,
    primary key(OrderID, Item)
    );
show columns from OrderT;
show columns from CorpT;
show columns from DetailT;