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