135
Tables (23)
chat_join
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- member_id — int8
- chat_room_id — int8
chat_message
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- message — varchar(255) — NOT NULL
- chat_join_id — int8 — NOT NULL
chat_room
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- name — varchar(255) — NOT NULL
member
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- birth_date — date
- email — varchar(255)
- gender — int2
- name — varchar(50)
- password — varchar(255)
- profile_img — varchar(200)
- refresh_token — varchar(255)
- role — int2
mentor
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- approved — bool
- bio — text
- matching_status — bool
- one_line_bio — varchar(200)
- portfolio — text
- member_id — int8 — NOT NULL
- tech_stacks — _varchar
mentor_mentee_matching
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- member_id — int8
- mentor_id — int8
- approved — bool
mentor_review
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- content — text
- member_id — int8
- mentor_id — int8
mentor_tech_stack
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- mentor_id — int8
- tech_stack_id — int8
notification
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- created_at — timestamp(6)
- message — varchar(255)
- read — bool — NOT NULL
- member_id — int8
post
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- content — varchar(255)
- file_paths — _varchar
- is_draft — bool
- likes — int4 — NOT NULL
- subject — varchar(255)
- tech_stacks — _varchar
- thumbnail — varchar(255)
- author_id — int8
post_comment
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- content — varchar(255)
- likes — int4 — NOT NULL
- author_id — int8
- parent_comment_id — int8
- post_id — int8
post_comment_likes
- comment_id — int8 — Primary key — NOT NULL
- member_id — int8 — Primary key — NOT NULL
post_likes
- post_id — int8 — Primary key — NOT NULL
- member_id — int8 — Primary key — NOT NULL
qna
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- content — varchar(255)
- is_draft — bool
- likes — int4 — NOT NULL
- subject — varchar(255)
- author_id — int8
qna_comment_likes
- comment_id — int8 — Primary key — NOT NULL
- member_id — int8 — Primary key — NOT NULL
qna_likes
- qna_id — int8 — Primary key — NOT NULL
- member_id — int8 — Primary key — NOT NULL
qnacomment
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- content — varchar(255)
- likes — int4 — NOT NULL
- author_id — int8
- parent_comment_id — int8
- qna_id — int8
report
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- reason — varchar(255) — NOT NULL
- status — varchar(255)
- type — varchar(255)
- post_id — int8
- qna_id — int8
- member_id — int8
- OFFENSIVE_LANGUAGE_AND_HATE::character — varying
- HARMFUL_OR_DANGEROUS_CONTENT::character — varying
- REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
- MALICIOUS_CONTENT::character — varying)::text)))
- COMPLETED::character — varying
- REJECTED::character — varying)::text)))
report_post
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- reason — varchar(255) — NOT NULL
- status — varchar(255)
- post_id — int8
- member_id — int8
- OFFENSIVE_LANGUAGE_AND_HATE::character — varying
- HARMFUL_OR_DANGEROUS_CONTENT::character — varying
- REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
- MALICIOUS_CONTENT::character — varying)::text)))
- COMPLETED::character — varying
- REJECTED::character — varying)::text)))
report_post_comment
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- reason — varchar(255) — NOT NULL
- status — varchar(255)
- comment_id — int8
- member_id — int8
- OFFENSIVE_LANGUAGE_AND_HATE::character — varying
- HARMFUL_OR_DANGEROUS_CONTENT::character — varying
- REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
- MALICIOUS_CONTENT::character — varying)::text)))
- COMPLETED::character — varying
- REJECTED::character — varying)::text)))
report_qna
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- reason — varchar(255) — NOT NULL
- status — varchar(255)
- qna_id — int8
- member_id — int8
- OFFENSIVE_LANGUAGE_AND_HATE::character — varying
- HARMFUL_OR_DANGEROUS_CONTENT::character — varying
- REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
- MALICIOUS_CONTENT::character — varying)::text)))
- COMPLETED::character — varying
- REJECTED::character — varying)::text)))
report_qnacomment
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- reason — varchar(255) — NOT NULL
- status — varchar(255)
- comment_id — int8
- member_id — int8
- OFFENSIVE_LANGUAGE_AND_HATE::character — varying
- HARMFUL_OR_DANGEROUS_CONTENT::character — varying
- REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
- MALICIOUS_CONTENT::character — varying)::text)))
- COMPLETED::character — varying
- REJECTED::character — varying)::text)))
tech_stack
- id — int8 — Primary key — NOT NULL
- created_date — timestamp(6)
- modified_date — timestamp(6)
- name — varchar(50)