mozip

Tables (3)

Card (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • slack_user_id (모집장)
  • title (제목)
  • members_count (모집 인원)
  • tags (중점 스택)
  • content (모집 내용)
  • status (모집 상태) — boolean
  • created_at (Field)
  • updated_at (Field7)

Untitled2

  • id (Key) — Primary key — NOT NULL
  • card_id (Key2) — Foreign key → Card.id — NOT NULL
  • slack_user_id (신청자)
  • name (신청자 명)
  • email (신청자 이메일)
  • introduce (한줄 소개)
  • status (승인/거절) — Boolean
  • created_at (Field6)
  • updated_at (Field7)

Users (유저)

  • id (Key) — Integer — Primary key — NOT NULL
  • slack_user_id (Slack_id) — VARCHAR(32)
  • slack_team_id (Field3) — VARCHAR(32)
  • slack_team_name (Field2) — VARCHAR(255)
  • slack_access_token (Field4) — TEXT
  • name (이름) — VARCHAR(255)
  • email (이메일) — VARCHAR(255)
  • created_at (생성일) — TIMESTAMP
  • updated_at (수정일) — TIMESTAMP