took
Tables (6)
Card (명함)
- id — bigint — Primary key — NOT NULL
- 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL
- 직군id (career_id) — bigint — Foreign key → Career.id — NOT NULL
- 썸네일정보 (preview_info) — enum — NOT NULL
- 닉네임 (nickname) — varchar — NOT NULL
- 이미지 (image_path) — varchar
- 관심도메인 (interest_domain) — json — NOT NULL
- 한줄소개 (summary) — varchar — NOT NULL
- 조직 (organization) — varchar
- SNS (sns) — json
- 활동지역 (region) — varchar
- 취미 (hobby) — varchar
- 최근소식 (news) — varchar
- 작성한글 (content) — json
- 참여프로젝트 (project) — json
- 생성시점 (created_at) — datetime — NOT NULL
- 수정시점 (updated_at) — datetime
- 삭제시점 (deleted_at) — datetime
Career (직군)
- id — bigint — Primary key — NOT NULL
- 직군 (job) — enum — NOT NULL
- 세부직군 (detail_job_en) — varchar — NOT NULL
- 세부직군_한글 (detail_job_kr) — json — NOT NULL
Folder (폴더)
- id — bigint — Primary key — NOT NULL
- 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL
- 이름 (name) — varchar — NOT NULL
- 생성시점 (created_at) — datetime — NOT NULL
- 수정시점 (updated_at) — datetime
- 삭제시점 (deleted_at) — datetime
Received_card (받은 명함)
- id — bigint — Primary key — NOT NULL
- 카드id (card_id) — bigint — Foreign key → Card.id — NOT NULL
- 사용자id (user_id) — bigint — Foreign key → User.id — NOT NULL
- 첫인상메모 (memo) — varchar
- 생성시점 (created_at) — datetime — NOT NULL
- 수정시점 (updated_at) — datetime
- 삭제시점 (deleted_at) — datetime
Received_card_folder (받은 명함 폴더)
- id — bigint — Primary key — NOT NULL
- 생성시점 (created_at) — datetime — NOT NULL
- 수정시점 (updated_at) — datetime
- 삭제시점 (deleted_at) — datetime
- 받은명함id (received_card_id) — bigint — Foreign key → Received_card.id — NOT NULL
- 폴더id (folder_id) — bigint — Foreign key → Folder.id — NOT NULL
User (사용자)
- id — bigint — Primary key — NOT NULL
- 이름 (name) — varchar — NOT NULL
- 이메일 (email) — varchar — NOT NULL
- 소셜id (oauth_id) — varchar
- 소셜플랫폼 (oauth_type) — enum
- 생성시점 (created_at) — datetime — NOT NULL
- 수정시점 (updated_at) — datetime
- 삭제시점 (deleted_at) — datetime