[Side Project] DB(DataBase) 기획/설계 V1

• Admin DB

Admin
id	int (auto increptment primary key)
email	varchar (Not Null)
password (encrypt)	varchar (Not Null)
mobile	varchar (Not Null)
created_at	datetime
updated_at	datetime

• Member DB

Member
id	int (auto increptment primary key)
email	varchar (Not Null)
password (encrypt)	varchar (Not Null)
address	varchar
mobile	varchar
created_at	datetime
updated_at	date

• Retailer DB

Retailer
id	int (auto increptment primary key)
business_registration_number	varchar (Not Null)
email	varchar (Not Null)
password (encrypt)	varchar (Not Null)
회사명	varchar (Not Null)
mobile (tel)	varchar (Not Null)
created_at	datetime
updated_at	datetime

• 구매신청 DB

구매신청
id	int (auto increptment primary key)
member_id	int
등록물건_id	int
quantity	int (Not Null)
title	varchar
status	varchar
created_at	datetime
updated_at	datetime

• Retailer 문의 DB

Retailer 문의
id	int (auto increptment primary key)
retailer_id	int
image (썸네일)	varchar
contents	long text
status	varchar
price	int
created_at	datetime
created_by	int
updated_at	datetime
updated_by	int
goods_name	varchar
note	text
category_id	int
회사이름	varchar

• 물건 DB

문의가 승인된 물건
id	int (auto increptment primary key)
문의_id	int
retailer_id	int
name	varchar (Not Null)
logo(썸네일)	varchar (Not Null)
password (encrypt)	varchar (Not Null)
contents	longtext
price	int
quantity	int
status	varchar (Not Null)
start_date	varchar (Not Null)
end_date	varchar (Not Null)
note	text
title	varchar
category_id	int
created_at	datetime
updated_at	datetime

• 주문 DB

주문
id	int (auto increptment primary key)
member_id	int
수량 (quantity)	int
가격 (price)	int
address	varchar
mobile (tel)	varchar
name	varchar
주문번호	int / varchar
created_at	datetime
updated_at	datetime
status	varchar

• 주소 DB

주소
id	int (auto increptment primary key)
member_id	int
name	varchar
mobile (tel)	varchar
address	varchar
기본배송지	boolean (TinyInt)
created_at	datetime
updated_at	datetime

• 카테고리 DB

Category
id	int (auto increptment primary key)
name	varchar(20)

1차적인 DB 설계가 끝나고 이후 ERD 다이어그램과 화면 기획을 통해 다시 한번 DB를 점검하기로 하였다.