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)