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)