sunday_0428

Tables (13)

alert

  • id — VARCHAR(255)
  • sender_id — VARCHAR(255) — NOT NULL
  • receiver_id — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

ongoing_project

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • team_leader_id — VARCHAR(255) — NOT NULL
  • status — ENUM('ONGOING', 'COMPLETED', 'CANCELLED') — NOT NULL
  • start_date — DATE
  • end_date — DATE

ongoing_project_member

  • id — BIGINT
  • ongoing_project_id — BIGINT — NOT NULL
  • user_id — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255)

peer_review

  • project_id — BIGINT — Primary key — NOT NULL
  • reviewer_id — VARCHAR(255) — Primary key — NOT NULL
  • reviewee_id — VARCHAR(255) — Primary key — NOT NULL
  • stars — ENUM('1', '2', '3', '4', '5') — NOT NULL
  • comment — TEXT — EX
  • comment_auth — ENUM('free', 'plus') — NOT NULL

portfolio

  • id — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • from_here — BOOLEAN — NOT NULL

profile

  • id — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • gender — ENUM('MALE', 'FEMALE')
  • age — INT
  • skill_level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED')
  • experience_years — INT
  • desired_type — ENUM('대면', '비대면', '상관없음')
  • residence_area — VARCHAR(255)
  • desired_job — VARCHAR(255)
  • personality — TEXT
  • project_id — BIGINT
  • self_intro — TEXT
  • main_url — VARCHAR(255)

project

  • id — BIGINT
  • owner_id — VARCHAR(255) — NOT NULL
  • domain — ENUM('개발', '예술') — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • type — ENUM('팀프로젝트') — NOT NULL
  • location_type — ENUM('대면', '비대면') — NOT NULL
  • duration_weeks — INT
  • team_size — INT
  • require_tag — VARCHAR(255)
  • require_text — TEXT
  • created_at — DATETIME — NOT NULL

project_application

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • user_id — VARCHAR(255) — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • message — TEXT
  • created_at — DATETIME — NOT NULL

project_tag

  • project_id — BIGINT
  • tag_id — BIGINT

report

  • id — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • project_id — BIGINT
  • message_id — BIGINT
  • status — ENUM('신고대기', '처리완료', '거부') — NOT NULL
  • report_reason — ENUM('욕설', '광고', '도배', '기타') — NOT NULL

tag

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL

user_account

  • user_id — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • provider — ENUM('github', 'kakao') — NOT NULL
  • role — ENUM('user', 'admin') — NOT NULL
  • banned — BOOLEAN — NOT NULL

user_tag

  • user_id — VARCHAR(255)
  • tag_id — BIGINT