gimalDB

Tables (10)

CART

  • 장바구니ID (CART_ID) — Primary key — NOT NULL
  • 상품ID (PRODUCT_ID) — Foreign key → PRODUCT.상품ID — NOT NULL
  • 회원ID (CUSTOMER_ID) — Foreign key → CUSTOMER.회원ID — NOT NULL
  • 수량 (COUNT)

CUSTOMER

  • 회원ID (CUSTOMER_ID) — Primary key — NOT NULL
  • 회원이름 (CUSTOMER_NAME) — NOT NULL
  • 회원등급 (GRADE)
  • 회원PW (CUSTOMER_PASSWORD)
  • 전화번호 (NUMBER)
  • 가입날짜 (REG_DATE)
  • 주소 (ADDRESS)

DETAIL

  • 주문상세ID (DETAIL_ID) — Primary key — NOT NULL
  • 거래ID (TRANSACTION_ID) — Foreign key → TRANSACTION.거래ID — NOT NULL
  • 수량 (COUNT)
  • 가격 (PRICE)
  • 상품ID (PRODUCT_ID) — Foreign key → PRODUCT.상품ID — NOT NULL

MANAGER

  • 관리자ID (MANAGER_ID) — Primary key — NOT NULL

NOTICE

  • 공지사항ID (NOTICE_ID) — Primary key — NOT NULL
  • 제목 (TITLE)
  • 내용 (CONTENTS)

PRODUCT

  • 상품ID (PRODUCT_ID) — Primary key — NOT NULL
  • 상품명 (PRODUCT_NAME)
  • 상점ID (STORE_ID) — Foreign key → STORE.상점ID — NOT NULL
  • 재고 (STOCK)
  • 개당가격 (PRICE)
  • 종류 (CATEGORY)

REVIEW

  • 거래ID (TRANSACTION_ID) — Foreign key → TRANSACTION.거래ID — NOT NULL
  • 작성날짜 (REVIEW_DATE)
  • 리뷰제목 (TITLE) — NOT NULL
  • 리뷰내용 (CONTENT)

STAFF

  • 직원ID (STAFF_ID) — Primary key — NOT NULL
  • 상점ID (STORE_ID) — Foreign key → STORE.상점ID — NOT NULL
  • 직원이름 (STAFF_NAME)
  • 직원PW (STAFF_PASSWORD)

STORE

  • 상점ID (STORE_ID) — Primary key — NOT NULL
  • 상점이름 (STORE_NAME)

TRANSACTION

  • 거래ID (TRANSACTION_ID) — Primary key — NOT NULL
  • 거래날짜 (TRANSACTION_DATE)
  • 회원ID (CUSTOMER_ID) — Foreign key → CUSTOMER.회원ID — NOT NULL
  • 거래상태 (STATE)