convenience_store
Tables (6)
Cart (장바구니)
- 상품ID (product_id) — NUMBER — Foreign key → Products.상품ID — NOT NULL
- 회원ID (user_id) — NUMBER — Foreign key → Users.회원ID — NOT NULL
- 담은 수량 (cart_quantity) — NUMBER — NOT NULL
- 입력일시 (created_at) — DATE — NOT NULL — SYSDATE
- 입력자 (created_by) — VARCHAR2(50) — NOT NULL
- 수정일시 (updated_at) — DATE — NOT NULL
- 수정자 (updated_by) — VARCHAR2(50) — NOT NULL
Category (카테고리)
- 카테고리ID (category_id) — NUMBER — Primary key — NOT NULL — ENUM
- 카테고리명 (category_name) — VARCHAR2(50) — NOT NULL — UNIQUE
- 입력일시 (created_at) — DATE — NOT NULL — SYSDATE
- 입력자 (created_by) — VARCHAR2(50) — NOT NULL
Order_product (구매상품)
- 구매ID (order_id) — NUMBER — Foreign key → Orders.구매ID — NOT NULL
- 상품ID (product_id) — NUMBER — Foreign key → Products.상품ID — NOT NULL
- 구매수량 (quantity) — NUMBER — NOT NULL
- 입력일자 (created_at) — DATE — NOT NULL
- 입력자 (created_by) — VARCHAR2(50) — NOT NULL
- 수정일시 (updated_at) — DATE — NOT NULL
- 수정자 (updated_by) — VARCHAR2(50) — NOT NULL
Orders (구매)
- 구매ID (order_id) — NUMBER — Primary key — NOT NULL
- 주문 일자 (order_date) — DATE — NOT NULL — SYSDATE
- 수정일자 (updated_at) — DATE — NOT NULL
- 수정자 (updated_by) — VARCHAR2(50)
- 총 주문금액 (total_price) — NUMBER — NOT NULL
- 회원ID (user_id) — NUMBER — Foreign key → Users.회원ID — NOT NULL
Products (상품)
- 상품ID (product_id) — NUMBER — Primary key — NOT NULL
- 상품명 (product_name) — VARCHAR2(100) — NOT NULL — UNIQUE
- 가격 (price) — NUMBER — NOT NULL
- 재고수량 (stock) — NUMBER — NOT NULL
- 상품 이미지 (image) — VARCHAR2(300) — NOT NULL — UNIQUE
- 입력일시 (created_at) — DATE — NOT NULL — SYSDATE
- 입력자 (created_by) — VARCHAR2(50) — NOT NULL
- 수정일시 (updated_at) — DATE — NOT NULL
- 수정자 (updated_by) — VARCHAR2(50) — NOT NULL
- 카테고리ID (category_id) — NUMBER — Foreign key → Category.카테고리ID — NOT NULL
Users (사용자)
- 회원ID (user_id) — NUMBER — Primary key — NOT NULL
- 이름 (username) — VARCHAR2(50) — NOT NULL
- 아이디 (login_id) — VARCHAR2(50) — NOT NULL — UNIQUE
- 비밀번호 (password) — VARCHAR2(100) — NOT NULL
- 전화번호 (phone) — VARCHAR2(13) — NOT NULL — UNIQUE
- 역할 (role) — VARCHAR2(20) — NOT NULL
- salt — VARCHAR2(100) — NOT NULL
- 탈퇴날짜 (deleted_at) — DATE
- 입력일시 (created_at) — DATE — NOT NULL — SYSDATE
- 입력자 (created_by) — VARCHAR2(50) — NOT NULL
- 수정일시 (updated_at) — DATE — NOT NULL
- 수정자 (updated_by) — VARCHAR2(50) — NOT NULL