6주차(2021.07.05 ~ 2021.07.11)

[binna]

[binna]

개발의 시작

1. ERD 설계
2. Table 생성
3. Entity 생성
4. Repository 생성
5. Repository 테스트
6. 연관관계 설정
7. 필요한 Query Method 생성

[binna]

6주차 수업에서는 1. ERD 설계, 2. Table 생성, 3. Entity 생성, 4. Repository 생성까지 진도 나감

[binna]

Table 생성을 위한 SQL

show databases; use study; show tables;

create table category ( id bigint(20) not null primary key auto_increment, type varchar(50) not null, title varchar(100), created_at datetime not null, created_by varchar(20) not null, updated_at datetime, updated_by varchar(20) );

create table user( id bigint(20) not null primary key auto_increment, account varchar(12) not null, password varchar(100) not null, status varchar(50) not null, email varchar(100), phone_number varchar(13), registered_at datetime, unregistered_at datetime, created_at datetime not null, created_by varchar(20) not null, updated_at datetime, update_by varchar(20) );

create table partner( id bigint(20) not null primary key auto_increment, name varchar(100) not null, status varchar(50) not null, address varchar(100) not null, call_center varchar(13), partner_number varchar(13), business_number varchar(16), ceo_name varchar(20), registered_at datetime, unregistered_at datetime, created_at datetime not null, created_by varchar(20) not null, updated_at datetime, updated_by varchar(20) );

create table item( id bigint(20) not null primary key auto_increment, status varchar(50) not null, name varchar(100) not null, title varchar(100) not null, content text, price decimal(12, 4) not null, brand_name varchar(50), registered_at datetime, unregistered_at datetime, created_at datetime not null , created_by varchar(20) not null, updated_at datetime, updated_by varchar(20) );

create table order_detail ( id bigint(20) not null primary key auto_increment, status varchar(50) not null, arrival_date datetime, quantity int not null, total_price decimal(12, 4) not null, created_at datetime not null, created_by varchar(20) not null , updated_at datetime, updated_by varchar(20) );

create table order_group ( id bigint(20) not null primary key auto_increment, status varchar(50) not null, order_type varchar(50) not null, rev_address text not null, rev_name varchar(50), payment_type varchar(50) not null, total_price decimal(12, 4) not null, total_quantity int not null, order_at datetime, arrival_date datetime, created_at datetime not null, created_by varchar(20) not null, updated_at datetime, updated_by varchar(20) );

create table admin_user ( id bigint(20) not null primary key auto_increment, account varchar(12) not null, password varchar(100) not null, status varchar(50) not null, role varchar(50) not null, last_login_at datetime, password_updated_at datetime, login_fail_count int, registered_at datetime, unregistered_at datetime, created_at datetime not null, created_by varchar(20) not null, updated_at datetime, updated_by varchar(20) );

alter table order_group add user_id bigint(20) not null; alter table order_group add constraint foreign key(user_id) references user(id);

alter table order_detail add order_group_id bigint(20) not null; alter table order_detail add constraint foreign key(order_group_id) references order_group(id);

alter table order_detail add item_id bigint(20) not null; alter table order_detail add constraint foreign key(item_id) references item(id);

alter table item add partner_id bigint(20) not null; alter table item add constraint foreign key(partner_id) references partner(id);

alter table partner add category_id bigint(20) not null; alter table partner add constraint foreign key(category_id) references category(id);