csBreaking
Tables (23)
Book (Untitled15)
- id (Key) — NOT NULL — Primary key — NOT NULL
- book_title (Field) — NOT NULL
- book_description (Field2)
- book_image_url (Field3)
- book_store_link (Field4)
answer (Untitled8)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- vote_count (Field2) — NOT NULL
- created_at (Field4) — NOT NULL
- post_id (Key2) — NOT NULL — Foreign key → qna_contents.id — NOT NULL
- user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
answer_comment (CopyOfUntitled8)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- vote_count (Field2) — NOT NULL
- created_at (Field4) — NOT NULL
- answer_id (Key2) — NOT NULL — Foreign key → answer.id — NOT NULL
- user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
answer_sheet (Untitled16)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- text (Field)
- question_id (Key3) — NOT NULL — Foreign key → question.id — NOT NULL
comment (8)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- date (Field4) — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- id (Key3) — NOT NULL — Foreign key → job_review_contents.id — NOT NULL
job_posting_contents (Untitled17)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- title (Field2) — NOT NULL
- tech_category (Field3) — NOT NULL
- incruit_link (Field4) — NOT NULL
- career (Field5) — NOT NULL
- start_end_time (Field6) — NOT NULL
- created_at (Field7) — NOT NULL
- view_count (Field8) — NOT NULL
- file (Field9)
job_review_contents (CopyOfUntitled17)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- title (Field2) — NOT NULL
- tech_category (Field3) — NOT NULL
- created_at (Field7) — NOT NULL
- view_count (Field8) — NOT NULL
- file (Field9)
- pass_fail (Field10)
- process_category (Field5) — NOT NULL
- comment_count (Field6) — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
login (Untitled14)
- id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- password (Field) — NOT NULL
message (Untitled12)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- date (Field2) — NOT NULL
- expired_date (Field3) — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
model_answer (Untitled6)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- question_id (Key2) — NOT NULL — Foreign key → question.id — NOT NULL
notification (Untitled9)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
notification_read (Untitled13)
- id (Key) — NOT NULL — Primary key — NOT NULL
- Field
oauthid (Untitled11)
- id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- access_token (Field) — NOT NULL
- provider (Field2) — NOT NULL
person (Untitled4)
- id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- email (Field2) — NULL
- mes_allowed (Field3) — NOT NULL
problem_scrap (Untitled18)
- scrap_id (Key3) — NOT NULL — Primary key — NOT NULL
- user_id (Key) — NOT NULL — Foreign key → user.user_id — NOT NULL
- id (Key2) — NOT NULL — Foreign key → question.id — NOT NULL
qna_contents (Untitled)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field2) — NOT NULL
- vote_count (Field3) — NOT NULL
- title (Field5) — NOT NULL
- tech_stack (Field) — NOT NULL
- created_at (Field6) — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- comment_count (Field4) — NOT NULL
- view_count (Field7) — NOT NULL
- file (Field8) — 추가
question (Untitled5)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- tech_stack (Field2) — NOT NULL
role (Untitled7)
- id (Key) — NOT NULL — Primary key — NOT NULL
- authority (Field) — NOT NULL
score (Untitled10)
- id (Key) — NOT NULL — Primary key — NOT NULL
- tech_stack (Field) — NOT NULL
- cur_score (Field2) — NULL
- prev_score (Field3) — NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
study_comment (CopyOf8)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- date (Field4) — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- id (Key3) — NOT NULL — Foreign key → study_contents.id — NOT NULL
study_contents (CopyOfUntitled172)
- id (Key) — NOT NULL — Primary key — NOT NULL
- text (Field) — NOT NULL
- title (Field2) — NOT NULL
- tech_category (Field3) — NOT NULL
- meeting_link (Field4) — NOT NULL
- on_offline (Field5) — NOT NULL
- created_at (Field7) — NOT NULL
- view_count (Field8) — NOT NULL
- per_week (Field9) — NOT NULL
- dayoftheweek (Field6) — NOT NULL
- mingrade (Field10)
- maxgrade (Field11)
- comment_count (Field12) — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
user (Untitled2)
- user_id (Key) — NOT NULL — Primary key — NOT NULL
- nick_name (Field) — NOT NULL
- exp (Field3) — NOT NULL
- point (Field4) — NOT NULL
- authority (Field5) — NOT NULL
- checkbox (Field6) — NOT NULL
- profile_image (Field2)
- tech_stack (Field7)
- tier (Field8) — NOT NULL
- email (Field9) — NULL
- mes_allowed (Field10) — NOT NULL
- user_pw (Field11) — NOT NULL
user_role (Untitled3)
- user_id (Key) — NOT NULL — Primary key — NOT NULL
- role_id (Key2) — NOT NULL — Primary key — NOT NULL