shinhancard
Tables (15)
Attached_files (파일)
- id (Key) — Primary key — NOT NULL
- file_name (파일명)
- file_url (파일url)
- id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
BaseEntity (Untitled3)
- created_at (생성시간)
- modified_at (수정시간)
- is_deleted (삭제/취소 여부)
Comments (답변)
- id (Key) — Primary key — NOT NULL
- inquiry_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
- is_accepted (채택여부) — boolean
- content (내용)
- id (답변담당자 id) — Foreign key → Inquiry_assignees.id — NOT NULL
- user_id (유저아이다) — Foreign key → User.id — NOT NULL
- accepted_at (채택일시)
- parent_id (상위댓글id) — Foreign key → Comments.id — NOT NULL
Divisions (본부)
- id (본부아이디) — Primary key — NOT NULL
- id (그룹아이디) — Foreign key → Groups.id — NOT NULL
- name (본부명)
Email_logs (이메일히스토리)
- id (Key) — Primary key — NOT NULL
- inquiry_id (Field)
- Field2
- inquiry_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
- user_id (유저아이디) — Foreign key → User.id — NOT NULL
FollowUp (추가문의)
- Key — Primary key — NOT NULL
- id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
- id (아이디2) — Foreign key → User.id — NOT NULL
- content (문의내용)
Groups (그룹)
- id (아이디) — Primary key — NOT NULL
- name (그룹병)
Inquiry (문의)
- id (문의아이디) — Primary key — NOT NULL
- id (유저id) — Foreign key → User.id — NOT NULL
- id (팀아이디) — Foreign key → Team.id — NOT NULL
- title (문의제목)
- content (문의내용)
- status (문의상태) — ENUM
- id_deleted (삭제여부)
- Field (파일url)
- isDraft (Field)
- id (팀아이디2) — Foreign key → Team.id — NOT NULL
Inquiry_assignees (답변담당자)
- id (Key) — Primary key — NOT NULL
- inquiry_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
- id (유저id) — Foreign key → User.id — NOT NULL
- is_read (확인여부)
Inquiry_observers (답변참조자)
- id (아이디) — Primary key — NOT NULL
- inquiry_id (문의id) — Foreign key → Inquiry.id — NOT NULL
- user_id (유저id) — Foreign key → User.id — NOT NULL
Interested_member (관심팀원)
- id (아이디) — Primary key — NOT NULL
- user_id (유저id) — Foreign key → User.id — NOT NULL
- interested_user_id (관심대상 유저 id) — Foreign key → User.id — NOT NULL
Scrap (스크랩)
- id (Key) — Primary key — NOT NULL
- user_id (유저아이디) — Foreign key → User.id — NOT NULL
- inqury_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
Team (팀)
- id (팀아이디) — Primary key — NOT NULL
- id (본부아이디) — Foreign key → Divisions.id — NOT NULL
- name (팀명)
TeamUser (Untitled5)
- id (아이디) — Primary key — NOT NULL
- user_id (유저아이디) — Foreign key → User.id — NOT NULL
- team_id (팀아이디) — Foreign key → Team.id — NOT NULL
- is_existed (팀탈퇴여부) — boolean
- role (역할) — ROLE("TEAM_LEADER", "TEAM_MEMBER")
- joinedAt (Field)
- leftAt (Field2)
User (유저)
- id (아이디) — Primary key — NOT NULL
- password (비밀번호)
- employee_id (사번)
- name (이름)
- email (이메일)
- phone_number (전화번호)
- image_url (프로필이미지url)