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