asdf
테이블 (12)
Untitled6
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR — NOT NULL
- extension — VARCHAR — NOT NULL
- route — VARCHAR — NOT NULL
- created_at — DATETIME — NOT NULL
location (Untitled2)
- id (pk) — 기본 키 — NOT NULL
- member_id (fk) — 외래 키 → member.id — NOT NULL
- city (Field)
member (Untitled)
- id (pk) — 기본 키 — NOT NULL
- company_type (Field)
- company_location (Field2)
- name (Field3)
- password (Field4)
- sex (Field5)
type (Untitled3)
- id (pk) — 기본 키 — NOT NULL
- member_id (pk2) — 외래 키 → member.id — NOT NULL
- name (Field)
구독
- id — BIGINT — 기본 키 — NOT NULL
- question_id — BIGINT
- answer_id — BIGINT
- user_id — BIGINT — NOT NULL
답변
- id — BIGINT — 기본 키 — NOT NULL
- body — VARCHAR — NOT NULL
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
- recommendation — BIGINT
- question_id — BIGINT — NOT NULL
- writor_id — BIGINT — NOT NULL
- editor_id — BIGINT
대댓글
- id — BIGINT — 기본 키 — NOT NULL
- question_id — BIGINT
- answer_id — BIGINT
- user_id — BIGINT — NOT NULL
- body — VARCHAR — NOT NULL
- created_at — DATETIME — NOT NULL
유저
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- reputation — BIGINT
- display_name — VARCHAR(20) — NOT NULL
- title — VARCHAR(50)
- about_me — VARCHAR(200)
- location — VARCHAR(100)
- website_link — VARCHAR(100)
- twitter_link — VARCHAR(100)
- github_link — VARCHAR(100)
유저_태그
- id — BIGINT — 기본 키 — NOT NULL
- tag_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
질문
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(100) — NOT NULL
- body — VARCHAR — NOT NULL
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME
- view — BIGINT
- recommendation — BIGINT
- editor_id — BIGINT
- writor_id — BIGINT — NOT NULL
질문_태그
- id — BIGINT — 기본 키 — NOT NULL
- question_id — BIGINT — NOT NULL
- tag_id — BIGINT — NOT NULL
태그
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR — NOT NULL
- description — VARCHAR