ai_agent_db

Tables (5)

chat (채팅)

  • id (ID) — Primary key — NOT NULL
  • member_id (회원ID) — Foreign key → member.id — NOT NULL
  • request (질의) — NOT NULL
  • response (응답)
  • created_time (주문일시)
  • del_yn (삭제여부)
  • created_at (생성시각)

document (사내문서)

  • Field

member (회원)

  • id (ID) — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • password (패스워드) — NOT NULL
  • name (이름)
  • age (나이)
  • del_yn (삭제여부)
  • created_at (생성시각)

order (주문)

  • id (ID) — Primary key — NOT NULL
  • member_id (회원ID) — Foreign key → member.id — NOT NULL
  • product_id (상품ID) — Foreign key → product.id — NOT NULL
  • quantity (주문수량)
  • del_yn (삭제여부)
  • created_at (주문일자)

product (상품)

  • id (ID) — Primary key — NOT NULL
  • name (상품명) — NOT NULL
  • category (카테고리)
  • price (상품가격) — NOT NULL
  • stock (상품재고) — NOT NULL
  • del_yn (삭제여부)
  • created_at (생성일자)
  • member_id (회원ID) — Foreign key → member.id — NOT NULL