【题目】创建CUSTOMERS表，字段为：ID：（非空，主键）bigint，NAME：（非空）varchar，AGE：int类型；创建ORDERS表，字段为：ID：...

创建CUSTOMERS表，字段为：ID：（非空，主键）bigint，NAME：（非空）varchar，AGE：int类型；创建ORDERS表，字段为：ID：（非空，主键，）bigint，ORDER_NUMBER：（非空）varchar，PRICE：double，CUSTOMER_ID ：（外键）bigint，设置级连删除；

答案：create table CUSTOMBERS(

ID bigint not null,

NAME varchar(15),

AGE int,

primary key (ID)

);

  create table ORDERS(

ID bigint not null,

ORDER_NUMBER varchar(15) not nulll,

PRICE double precision,

CUSTOMER_ID bigint,

        primary key(ID),

);

alter table ORDERS add constraint FK_CUSTOMER foreign key (CUSTOMER_ID) references CUSTOMERS(ID) on delete cascade;