CalmProject

Tables (7)

Comments (댓글)

  • id (게시판 id) — Int — Foreign key → Posts.id — NOT NULL
  • user_id (유저아이디) — Int — Foreign key → Posts.m_id — NOT NULL
  • content (댓글내용) — Int
  • created_dt (작성일자) — datetiem
  • Field

Matching (매칭)

  • id (매칭식별자) — Int — Primary key — NOT NULL
  • representative_id (매칭신청자) — Int — Foreign key → Users.id — NOT NULL
  • matching_type (매칭 타입) — String
  • required_position (필요 포지션) — String
  • status (매칭상태) — String
  • created_dt (팀매칭시간) — datetime
  • Field

Posts (팀게시판)

  • id (게시판 id) — Int — Primary key — NOT NULL
  • t_id (팀 고유 식별자) — Foreign key → Teams.t_id — NOT NULL
  • m_id (매칭아이디) — Int — Foreign key → Teams.m_id — NOT NULL
  • created_dt (생성일자) — datetime
  • Field

Team_members (매칭된 팀 멤버)

  • tm_id (고유 식별자) — Int — Primary key — NOT NULL
  • user_id (사용자 고유 식별자) — Int — Foreign key → Users.id — NOT NULL
  • t_id (팀 고유 식별자) — Foreign key → Teams.t_id — NOT NULL
  • m_id (매칭아이디) — Int — Foreign key → Matching.id — NOT NULL
  • Key — Foreign key → Teams.m_id — NOT NULL
  • joinde_at (팀가입시간) — Datetime
  • status (상태 (탈퇴여부))

Teams (팀)

  • t_id (팀 고유 식별자) — Primary key — NOT NULL
  • m_id (매칭아이디) — Int — Primary key — NOT NULL
  • t_name (팀 이름) — String
  • created_dt (팀구성시간) — datetime
  • Field2

User_tech_stacks (유저 기술스택)

  • id (스택 식별자) — Int — Primary key — NOT NULL
  • user_id (사용자 고유 식별자) — Int — Foreign key → Users.id — NOT NULL
  • tech_name (기술이름)
  • created_dt (선택 시간) — datetime
  • updated_dt (수정시간) — datetime
  • Field2

Users (회원 테이블)

  • id (사용자 고유 식별자) — Int — Primary key — NOT NULL
  • email (이메일) — String — Primary key — NOT NULL
  • password (암호화된 비밀번호) — String
  • name (사용자 이름) — String
  • created_dt (계정 생성 시간) — datetime
  • updated_dt (정보 수정 시간) — datetme
  • position (역할) — String
  • Field2