kakao_mlms

Tables (4)

Image (Untitled)

  • ID (id) — PK — Primary key — NOT NULL
  • 입력된 이름 (origin_name) — NN
  • 저장되는 이름 (uuid_name) — NN
  • 확장자 (extension) — NN
  • 카테고리 (category) — NN
  • qna_id — FK — Foreign key → qnas.ID — NOT NULL

answers (답변)

  • ID (id) — PK — Primary key — NOT NULL
  • 내용 (content) — NN
  • 생성 날짜 (created_date) — NN
  • qna_id — FK — Foreign key → qnas.ID — NOT NULL
  • admin_id — FK — Foreign key → users.ID — NOT NULL

qnas (Q&A)

  • ID (id) — PK — Primary key — NOT NULL
  • 제목 (title) — NN
  • 내용 (content) — NN
  • 카테고리 (category) — NN
  • 생성 날짜 (created_date) — NN
  • 답변 여부 (is_answer) — NN
  • 비공개여부 (is_blind) — NN
  • user_id — FK — Foreign key → users.ID — NOT NULL

users (유저)

  • ID (id) — PK — Primary key — NOT NULL
  • 소셜ID (social_id) — NN
  • 비밀번호 (password) — NN
  • 로그인경로 (provider) — NN
  • 역할 (role) — NN
  • 가입 날짜 (created_date) — NN
  • 닉네임 (nickname) — NN
  • 로그인여부 (is_login) — NN
  • 리프레시토큰 (refresh_token) — NN