映射值对象sql.txt

来自「刚用java做的网上购物车 做毕业论文用的 有需要的朋友可以参考下」· 文本 代码 · 共 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)
);