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