ShinhanCard
Tables (13)
Answer (답변)
- AnswerId (answer_id) — BIGINT — Primary key — NOT NULL
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
- content (Field) — TEXT
- createdAt (created_at) — DATETIME
- isAdopted (is_adopted) — BOOLEAN
AnswerAssignee (답변담당자)
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
- assignedAt (assigned_at)
- lastEnterdAt (last_entered_at) — DATETIME
- notifiedAt (notified_at) — DATETIME
EmailLog (메일 로깅)
- logId (email_log_id) — BIGINT — Primary key — NOT NULL
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
- AnswerId (answer_id) — BIGINT — Foreign key → Answer.AnswerId — NOT NULL
- sentAt (sent_at) — DATETIME
- status (Field2) — ENUM
- errorMessage (error_message) — BIGINT
FollowUp (추가 문의)
- followUpId (followUp_id) — BIGINT — Primary key — NOT NULL
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
- content (Field) — TEXT
- createdAt (create_at) — DATETIME
Headquarter (본부)
- headquarterId (headquarter_id) — BIGINT — Primary key — NOT NULL
- groupId (group_id) — BIGINT — Foreign key → OrgGroup.groupId — NOT NULL
- Field
Inquiry (문의)
- inquiryId (inquiry_id) — BIGINT — Primary key — NOT NULL
- content (Field) — TEXT
- isDraft (is_draft) — BOOLEAN
- status (Field2) — ENUM
- createdAt (create_at) — DATETIME
- updatedAt (updated_at) — DATETIME
- isDeleted (is_deleted) — BOOLEAN
- teamId (team_id) — BIGINT — Foreign key → Team.teamId — NOT NULL
InquiryReference (문의참조자)
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
Notification (알림)
- notificationId (notification_id) — BIGINT — Primary key — NOT NULL
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
- type (Field) — ENUM
- content (Field2) — TEXT
- isRead (is_read) — BOOLEAN
- lastUpdatedAt (last_updated_at) — DATETIME
OrgGroup (그룹)
- groupId (group_id) — BIGINT — Primary key — NOT NULL
- name (Field)
Scrap (스크랩)
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
Team (팀)
- teamId (team_id) — BIGINT — Primary key — NOT NULL
- headquarterId (headquarter_id) — BIGINT — Foreign key → Headquarter.headquarterId — NOT NULL
- status (Field) — ENUM
User (사용자)
- userId (user_id) — BIGINT — Primary key — NOT NULL
- userName (user_name) — VARCHAR(100)
- Field
User-Team (사용자-팀 중간테이블)
- teamId (team_id) — BIGINT — Foreign key → Team.teamId — NOT NULL
- userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
- role (Field) — ENUM
- joinedAt (joined_at) — DATETIME
- leftAt (left_at) — DATETIME