stackoverflow
테이블 (10)
MEMBER_ROLE (Untitled)
- memberId (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- roles (ROLES) — VARCHAR(255)
Untitled (QUESTION_COMMENT)
- Key (QUESTION_COMMENT_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
- id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
- id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- Field (CONTENT) — text — NOT NULL
- Field2 (CREATED_AT) — datetime — NOT NULL
- Field3 (MODIFIED_AT) — datetime — NOT NULL
Untitled (TAG)
- Key (TAG_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
- Field (TAG_NAME) — varchar(255) — NOT NULL
- Field2 (TAG_DESCRIPTION) — varchar(255)
- Field (CREATED_AT) — datetime — NOT NULL
- Field2 (MODIFIED_AT) — datetime — NOT NULL
Untitled (QUESTION_TAG)
- Key (QUESTION_TAG_ID) — bigint — 기본 키 — NOT NULL
- id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
- Key (TAG_ID) — bigint — 외래 키 → Untitled.Key — NOT NULL — Auto Increment
- Field (CREATED_AT) — datetime — NOT NULL
- Field2 (MODIFIED_AT) — datetime — NOT NULL
Untitled (ANSWER)
- Key (ANSWER_ID) — bigint — 기본 키 — NOT NULL
- id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
- id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- Field (CONTENT) — text — NOT NULL
- Field2 (ACCEPTED) — boolean — NOT NULL
- Field (CREATED_AT) — datetime — NOT NULL
- Field2 (MODIFIED_AT) — datetime — NOT NULL
Untitled (ANSWER_COMMENT)
- Key (ANSWER_COMMENT_ID) — bigint — 기본 키 — NOT NULL
- id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- Key (ANSWER_ID) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (CONTENT) — TEXT — NOT NULL
- Field2 (CREATED_AT) — datetime — NOT NULL
- Field3 (MODIFED_AT) — datetime — NOT NULL
Untitled (VOTE)
- Key (VOTE_ID) — bigint — 기본 키 — NOT NULL
- id (VOTER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
- Key (ANSWER_ID) — bigint — 외래 키 → Untitled.Key — NOT NULL
- voteStatus (VOTE_STATUS) — varhcar(255)
Untitled2
- profileImageId (PROFILE_IMAGE_ID) — bigint — 기본 키 — NOT NULL
- memberId (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- uploadFileName (UPLOAD_FILE_NAME) — varchar(255)
- storeFIleName (STORE_FILE_NAME) — varchar(255)
- createdAt (CREATED_AT) — datetime
- modifiedAt (MODIFIED_AT) — datetime
질문 (QUESTION)
- id (QUESTION_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
- id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
- title (QUESTION_TITLE) — varchar(255) — NOT NULL
- content (CONTENT) — text — NOT NULL
- view (VIEWS) — int — NOT NULL
- adopt (IS_ADOPTED) — boolean
- Field (CREATED_AT) — datetime — NOT NULL
- Field2 (MODIFIED_AT) — datetime — NOT NULL
회원 (MEMBER)
- id (MEMBER_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
- email (EMAIL) — varchar(255) — NOT NULL
- password (PASSWORD) — varchar(255) — NOT NULL
- displayName (USER_NAME) — varchar(255) — NOT NULL
- createdAt (CREATED_AT) — datetime — NOT NULL
- modifiedAt (MODIFIED_AT) — datetime — NOT NULL
- reputation — int
- Field2