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 (상품 재고량)