ERD

테이블 생성 SQL 문

create table user(
	id bigint auto_increment primary key,
	user_id varchar(255) not null,
	user_pw varchar(255) not null,
	user_name varchar(255),
	user_point int,
	user_join_date date default now(),
	user_role int,
	user_del_yn tinyint,
	unique key(id, user_id, user_pw)
);

create table product(
	id bigint auto_increment primary key,
	product_name varchar(255),
	product_code varchar(255),
	product_price bigint,
	product_img_url varchar(255),
	product_category int,
	product_del_yn tinyint,
	
);

create table order_item(
	id bigint auto_increment primary key,
	order_item_price bigint,
	order_item_amount int,
	product_id bigint not null,
	order_list_id bigint,
	
	foreign key(order_list_id) references order_list(id),
	foreign key(product_id) references product(id);
);

create table order_list(
	id bigint auto_increment primary key,
	order_list_time datetime,
	order_list_status int
	order_list_total_price int,
	user_id bigint,
	order_list_del_yn tinyint,
	foreign key(user_id) references useer(id)
);