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