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