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