erd
Tables (5)
TB_ACCOUNT (회원)
- ACCOUNT_ID (회원 ID) — Primary key — NOT NULL
- EMAIL (이메일)
- PASSWORD (패스워드)
- ROLE (권한)
- CREATED_AT (등록일시)
- MODIFIED_AT (수정일시)
TB_ORDER (주문)
- ORDER_ID (주문ID) — Primary key — NOT NULL
- ORDER_TOTAL_AMOUNT (주문 총 금액)
- SHIPPING_FEE (배송비)
TB_ORDER_PRODUCT (주문-상품)
- ORDER_PRODUCT_ID (주문-상품 ID) — Primary key — NOT NULL
- ORDER_ID (주문ID) — Foreign key → TB_ORDER.ORDER_ID — NOT NULL
- PRODUCT_ID (상품 ID) — Foreign key → TB_PRODUCT.PRODUCT_ID — NOT NULL
- ORDER_PRDUCT_QUANTITY (주문 상품수량)
- AMOUNT (금액)
TB_POST (게시글)
- POST_ID (게시글 ID) — Primary key — NOT NULL
- ACCOUNT_ID (회원 ID) — Foreign key → TB_ACCOUNT.ACCOUNT_ID — NOT NULL
- TITLE (제목)
- CONTENT (내용)
- CREATED_AT (등록일시)
- MODIFIED_AT (수정일시)
- CREATED_BY (등록자)
- MODIFIED_BY (수정자)
TB_PRODUCT (상품)
- PRODUCT_ID (상품 ID) — Primary key — NOT NULL
- PRODUCT_NAME (상품명)
- PRODUCT_PRICE (상품 가격)
- PRODUCT_QUANTITY (상품 재고량)