cu2
Tables (29)
Copy Of follow (CopyOffollow)
- follow_id (id) — uuid — Primary key — NOT NULL
- from_user_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
Untitled
- coach_category_id — uuid — Foreign key → coach_category.coach_category_id — NOT NULL
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
Untitled2
- code_category_id (Key) — uuid — Foreign key → code_category.code_category_id — NOT NULL
- User_id (id) — uuid — Foreign key → user.User_id — NOT NULL
blog
- Blog_id (id) — uuid — Primary key — NOT NULL
- title — varchar(200)
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
blog_comment (CopyOfblog)
- Blog_Comment_id (id) — uuid — Primary key — NOT NULL
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
- Blog_id (id3) — uuid — Foreign key → blog.Blog_id — NOT NULL
blog_image
- blog_image_id (id) — uuid — Primary key — NOT NULL
- url — url
- Blog_id (id2) — uuid — Foreign key → blog.Blog_id — NOT NULL
- 순서 (order)
blog_like
- blog_like_id (id) — uuid — Primary key — NOT NULL
- Blog_Comment_id (id2) — uuid — Foreign key → blog_comment.Blog_Comment_id — NOT NULL
- User_id (id3) — uuid — Foreign key → user.User_id — NOT NULL
blog_tag
- blog_tag_id (id) — uuid — Primary key — NOT NULL
- name — varchar(20)
coach_category
- coach_category_id — uuid — Primary key — NOT NULL
- name — varchar(20)
- image — url
coach_profile
- id — uuid — Foreign key → user.User_id — NOT NULL
- org (organization_name) — varchar(20)
- org (organization_type) — enum
- org (organization_email) — varchar(40)
- dept (department) — varchar(40)
- job — varchar(40)
- isHiring (is_hiring) — boolean
- title — varchar(200)
- contents — text
- image — url
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
coach_profile_tag (Untitled3)
- Key — Primary key — NOT NULL
- User_id (id) — uuid — Foreign key → coach_profile.id — NOT NULL
- id (id2) — uuid — Foreign key → coach_tag.id — NOT NULL
coach_tag
- id — uuid — Primary key — NOT NULL
- name — string
coachingus_answer
- coachingus_answer_id (id) — uuid — Primary key — NOT NULL
- title — varchar(200)
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- coachingus_question_id (id2) — uuid — Foreign key → coachingus_question.coachingus_question_id — NOT NULL
coachingus_answer_reaction
- reaction_id (id) — uuid — Primary key — NOT NULL
- status — enum
- comment — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
- coachingus_answer_id (id3) — uuid — Foreign key → coachingus_answer.coachingus_answer_id — NOT NULL
coachingus_question
- coachingus_question_id (id) — uuid — Primary key — NOT NULL
- title — varchar(200)
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
- type — enum
- toCoach (Field)
coachingus_question_tag
- coachingus_question_tag_id (id) — uuid — Primary key — NOT NULL
- name — varchar(20)
code_category
- code_category_id (Key) — uuid — Primary key — NOT NULL
- name — varchar(20)
- image — url
codingus_answer (CopyOfcodingus_question)
- codingus_answer_id (id) — uuid — Primary key — NOT NULL
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
- codingus_question_id (id3) — uuid — Foreign key → codingus_question.codingus_question_id — NOT NULL
codingus_answer_like
- codingus_answer_like_id (id) — uuid — Primary key — NOT NULL
- codingus_answer_id (id2) — uuid — Foreign key → codingus_answer.codingus_answer_id — NOT NULL
- User_id (id3) — uuid — Foreign key → user.User_id — NOT NULL
codingus_question
- codingus_question_id (id) — uuid — Primary key — NOT NULL
- title — varchar(200)
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
codingus_question_tag (CopyOfblog_tag)
- codingus_question_tag_id (id) — uuid — Primary key — NOT NULL
- name — varchar(20)
column
- Column_id (id) — uuid — Primary key — NOT NULL
- title — varchar(200)
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
column_comment (CopyOfcolumn)
- Column_comment_id (id) — uuid — Primary key — NOT NULL
- contents — text
- createdAt — Datetime
- updatedAt — Datetime
- deletedAt — Datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
- Column_id (id3) — uuid — Foreign key → column.Column_id — NOT NULL
column_image
- column_tag_id (id) — uuid — Primary key — NOT NULL
- url — url
- Column_id (id2) — uuid — Foreign key → column.Column_id — NOT NULL
column_like
- column_like_id (id) — uuid — Primary key — NOT NULL
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
- Column_id (id3) — uuid — Foreign key → column.Column_id — NOT NULL
column_tag
- column_tag_id (id) — uuid — Primary key — NOT NULL
- name — varchar(20)
follow
- follow_id (id) — uuid — Primary key — NOT NULL
- from_user_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
point_transaction
- point_trsc_id (id) — uuid — Primary key — NOT NULL
- impUid — uuid
- amount — int
- status — enum
- createdAt — datetime
- User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
user
- User_id (id) — uuid — Primary key — NOT NULL
- name — varchar(10)
- Email (email) — varchar(10)
- Phone (phone_number) — varchar(20)
- password — varchar
- usertype (status) — enum
- interest (code_interest) — varchar(20)
- interest (coach_interest) — varchar(20)
- point — int
- score — int
- createdAt — Datetime
- deletedAt — Datetime
- updatedAt — Datetime