LG gram
Tables (8)
conversations
- conversation_id — varchar(20) — Primary key — NOT NULL — 대화 쓰레드
- user_id — varchar(20) — NOT NULL
- title — varchar(100)
- context_data — json — 대화 문맥 (context)
- type — tinyint
- ai_setting — varchar(100)
- created — timestamp(6)
- modified — timestamp(6)
messages
- message_id — varchar(20) — Primary key — NOT NULL
- conversation_id — varchar(20) — NOT NULL
- user_id — varchar(20) — NOT NULL
- creator — varchar(20) — user_id or gpt(gpt version)
- body_text — mediumtext
- body_blockskit — mediumtext — Body data for Block-kit
- status — enum('sent', 'read', 'failed')
- created — timestamp(6)
- modified — timestamp(6)
usage_metric
- user_id — varchar(20) — Primary key — NOT NULL — user_id
- type — tinyint — 1:chatbot, 2:taskify, 3:summarize, 4:assistant, 5:translate
- latency — float — 실행시간
- in_token_size — int — NOT NULL — int
- out_token_size — int
- total_token_size — int — NOT NULL — total
- payload — json — payload
- created — timestamp — created
- response_id — varchar(20) — NOT NULL — AI response id
user_emails
- email_id — varchar(20) — Primary key — NOT NULL — 이메일아이디
- user_id — varchar(20) — NOT NULL — 사용자 아이디
- email — varchar(320) — NOT NULL — 이메일
- is_dfl — enum('Y', 'N') — NOT NULL — 대표메일여부
- verified — tinyint — NOT NULL — 이메일인증여부(0.미인증 1.인증완료)
- created — timestamp
- modified — timestamp
user_oauth
- user_oauth_id — varchar(20) — Primary key — NOT NULL — OAuth 레코드 ID
- user_id — varchar(20) — NOT NULL — user 테이블의 user_id
- provider — varchar(50) — NOT NULL — 소셜 로그인 제공자 (google, microsoft 등)
- provider_user_id — varchar(255) — NOT NULL — OAuth 제공자의 고유 사용자 ID
- access_token — varchar(255) — NOT NULL — Access Token
- refresh_token — varchar(255) — NOT NULL — Refresh Token
- expires_at — timestamp — NOT NULL — Token 만료 시간
user_password
- user_password_id — varchar(20) — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- salt — varchar(20) — NOT NULL
- hash — varchar(200) — NOT NULL
- skip_date — timestamp(6) — NOT NULL
- created — timestamp(6) — NOT NULL
user_profiles
- user_id — varchar(20) — Primary key — NOT NULL — 사용자아이디
- user_name — varchar(150)
- bg_color — varchar(10) — 프로필 사진 백그라운드 컬러코드
- language — varchar(10)
- tel — varchar(20) — 디폴트 전화번호
- timezone — varchar(50) — 타임존아이디
- timezone_auto_flag — tinyint — 타임존 auto 설정 여부 (1.auto 2.manual)
- created — timestamp — NOT NULL
- modified — timestamp
users
- user_id — varchar(20) — Primary key — NOT NULL — 사용자아이디
- active_flag — tinyint — 1.정상 2.정지 3.탈퇴
- created — timestamp — NOT NULL
- modified — timestamp