Taskify

Tables (4)

Card (card)

  • 카드_id (card_id) — NOT NULL — Primary key — NOT NULL
  • 카테고리_id (category_id) — NOT NULL — Foreign key → Category.카테고리_id — NOT NULL
  • 제목 (title) — NOT NULL
  • 내용 (content) — NOT NULL
  • 디바이스 (device) — NOT NULL

Category (category)

  • 카테고리_id (category_id) — NOT NULL — Primary key — NOT NULL
  • 회원_id (member_id) — NOT NULL — Foreign key → Member.회원_id — NOT NULL
  • 컬럼명 (topic) — NOT NULL
  • 컬럼명_영어 (topic_en) — NOT NULL

Member (member)

  • 회원_id (member_id) — NOT NULL — Primary key — NOT NULL
  • 이름 (name) — NOT NULL
  • 아이디 (login_id) — NOT NULL
  • 비밀번호 (password) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL

Record (record)

  • 기록_id (record_id) — NOT NULL — Primary key — NOT NULL
  • 회원_id (member_id) — NOT NULL — Foreign key → Member.회원_id — NOT NULL
  • 생성시간 (created_at) — NOT NULL
  • 작업 (task_type) — NotNull
  • 아이콘 (icon)
  • 활동기록 (activity) — NotNull