DB 정의

create database 2ny;
use 2ny;

create user 2ny identified by '2ny';
show grants for 2ny;
GRANT USAGE ON *.* TO `2ny`@`%`;
GRANT ALL PRIVILEGES ON `2ny`.* TO `2ny`@`%`;

ERD

• sql 쿼리

테이블 정의서

실사용

User

Review

Item

ItemCategory

ItemOrder

Wish

Cart

Order

ItemCart

테스트용

Test

TestCategory