베이글몬스터 최종 ERD
테이블 (6)
CartProducts
- cartProductId — bigint(20) — 기본 키 — NOT NULL
- cartId — bigint(20) — 외래 키 → Carts.cartId — NOT NULL
- productId — bigint(20) — 외래 키 → Products.productId — NOT NULL
- quantity — int(11) — NOT NULL
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Carts
- cartId — bigint(20) — 기본 키 — NOT NULL
- userId — bigint(20) — 외래 키 → Users.userId — NOT NULL
- storeId — bigint(20) — 외래 키 → Stores.storeId — NOT NULL
- totalPrice — int(11) — NOT NULL
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
- storeStatus — varchar(255)
Notifications
- notificationId — bigint(20) — 기본 키 — NOT NULL
- userId — bigint(20) — 외래 키 → Users.userId — NOT NULL
- cartId — bigint(20) — 외래 키 → Carts.cartId — NOT NULL
- content — varchar(255)
- createdDate — timestamp — NOT NULL
- rd — boolean — NOT NULL
- expriationTime — timestamp — NOT NULL
Products
- productId — bigint(20) — 기본 키 — NOT NULL
- storeId — bigint(20) — 외래 키 → Stores.storeId — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255)
- price — int(11) — NOT NULL
- productPictureUrl — text
- popularity — int(11) — NOT NULL — 일반, 인기
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
- status — boolean — NOT NULL
Stores
- storeId — bigint(20) — 기본 키 — NOT NULL
- userId — bigint(20) — 외래 키 → Users.userId — NOT NULL
- name — varchar(255) — NOT NULL
- address — varchar(255) — NOT NULL
- storePictureUrl — text
- phone — varchar(20) — NOT NULL
- content — varchar(255)
- productCreatedTime — time
- openedTime — time
- closedTime — time
- closedDays — varchar(255)
- createdDate — timestamp — NOT NULL
- modifiedDate — timestamp — NOT NULL
Users
- userId — bigint(20) — 기본 키 — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- phone — varchar(11) — NOT NULL
- email — varchar(100) — NOT NULL
- role — varchar(100) — NOT NULL