markinfo

테이블 (12)

admin

  • admin_id — varchar(100) — 기본 키 — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • position — varchar(100)
  • task — varchar(100)
  • role — varchar(100) — NOT NULL
  • last_login_at — timestamp

admin_signin

  • admin_signin_id — varchar(100) — 기본 키 — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • signin_at — timestamp — NOT NULL
  • status — varchar(100)

admin_token

  • admin_token_id — varchar(100) — 기본 키 — NOT NULL
  • admin_signin_id — varchar(100) — NOT NULL
  • aws_refresh_token — varchar — NOT NULL
  • aws_id_token — varchar — NOT NULL
  • aws_access_token — varchar — NOT NULL
  • create_at — timestamp
  • status — varchar(100)

alembic_version

  • version_num — varchar(32) — NOT NULL

customer

  • 유저ID (user_id) — varchar(100) — 기본 키 — NOT NULL
  • email — varchar(100) — NOT NULL
  • joined_at — timestamp — NOT NULL
  • last_login_at — timestamp
  • withdrawal_at — timestamp
  • is_admin — boolean
  • phone — varchar(100)
  • name — varchar(100) — NOT NULL
  • confirm — boolean
  • nickname — varchar(100)
  • kakao — boolean
  • google — boolean
  • marketing_sms — boolean
  • marketing_email — boolean
  • img — varchar
  • memo — varchar

naimy

  • naimy_id — varchar(100) — 기본 키 — NOT NULL
  • 유저ID (user_id) — varchar(100) — 외래 키 → customer.유저ID — NOT NULL
  • create_at — timestamp — NOT NULL
  • category — varchar(100) — NOT NULL
  • usage — varchar(100)
  • description — varchar(100)
  • tone — jsonb — NOT NULL
  • seed — jsonb — NOT NULL
  • target — jsonb
  • trend — jsonb
  • language — jsonb
  • level — double
  • sub_category — jsonb
  • model — varchar(100)

naimy_result

  • naimy_result_id — varchar — 기본 키 — NOT NULL
  • naimy_id — varchar(100) — 외래 키 → naimy.naimy_id — NOT NULL
  • brand_name — varchar — NOT NULL
  • korean_pronunciation — varchar — NOT NULL
  • meaning — varchar — NOT NULL
  • bookmark — boolean
  • bookmark_at_time — timestamp
  • used_technique — jsonb — NOT NULL
  • like — boolean
  • like_at_time — timestamp
  • create_at — timestamp

risa

  • risa_id — varchar — 기본 키 — NOT NULL
  • user_id — varchar(100) — 외래 키 → customer.유저ID — NOT NULL
  • create_at — timestamp — NOT NULL
  • status — varchar(100) — NOT NULL
  • brand_name — varchar(1000) — NOT NULL
  • description — varchar
  • discrimination — jsonb
  • kipris — jsonb
  • name_check — jsonb
  • category — jsonb
  • code — jsonb

signin

  • signin_id — varchar — 기본 키 — NOT NULL
  • 유저ID (user_id) — varchar(100) — 외래 키 → customer.유저ID — NOT NULL
  • signin_at — timestamp — NOT NULL
  • status — varchar

survey

  • survey_id — varchar — 기본 키 — NOT NULL
  • naimy_id — varchar — NOT NULL
  • result — jsonb — NOT NULL
  • category — varchar — NOT NULL
  • create_at — timestamp

token

  • token_id — varchar — 기본 키 — NOT NULL
  • create_at — timestamp
  • status — varchar
  • aws_refresh_token — varchar — NOT NULL
  • aws_access_token — varchar — NOT NULL
  • aws_id_token — varchar — NOT NULL
  • signin_id — varchar — 외래 키 → signin.signin_id — NOT NULL

챗봇 (chatbot)

  • 챗봇ID (chatbot_id) — varchar(100) — 기본 키 — NOT NULL
  • 유저ID (user_id) — varchar(100) — 외래 키 → customer.유저ID — NOT NULL
  • 생성시간 (create_at) — datetime — NOT NULL
  • 마지막 업데이트 시간 (update_at) — datetime
  • 제목 (title) — varchar(100)
  • 대화기록 (conversation) — jsonb
  • 네이미ID (naimy_id) — varchar(100) — 외래 키 → naimy.naimy_id
  • 분류 (usage) — varchar
  • 업종 (category) — varchar
  • 서브업종 (sub_category) — varchar
  • 상세설명 (description) — varchar
  • 분위기 (tone) — jsonb
  • 시드단어 (seed) — jsonb
  • 타겟 (target) — jsonb
  • 트렌드 (trend) — jsonb
  • 언어 (language) — jsonb
  • 모델 (model) — varchar(100)
  • 레벨 (level) — float
  • 엑셀버젼 (version) — varchar(10)