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 (생성시각)
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