映射值对象sql.txt

来自「刚用java做的网上购物车 做毕业论文用的 有需要的朋友可以参考下」· 文本 代码 · 共 71 行

TXT
71
字号
drop table customers;
create table customers(
    id    bigint   primary key,
    name  varchar(10),
    age   integer
);

drop table images;
create table images(
    customer_id bigint
		references     customers(id),
    filename    varchar(10),
    constraint  primary key(customer_id,filename)    
);
===================================================
drop table customers;
create table customers(
    id    bigint   primary key,
    name  varchar(10),
    age   integer
);

drop table images;
create table images(
    id    bigint    primary key,
    customer_id bigint
		references     customers(id),
    filename    varchar(10)
);
==============================================
drop table customers;
create table customers(
    id    bigint   primary key,
    name  varchar(10),
    age   integer
);

drop table images;
create table images(
    customer_id bigint
		references     customers(id),
    position    bigint,	
    filename    varchar(10),
    constraint  primary key(customer_id,position)
);
==============================================
drop table customers;
create table customers(
    id    bigint   primary key,
    name  varchar(10),
    age   integer
);

drop table images;
create table images(
    customer_id bigint
		references     customers(id),
    image_name  varchar(10),
    filename    varchar(10),
    constraint  primary key(customer_id,image_name)
);









⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?