0506TEST
Tables (8)
DEPT (Untitled)
- 부서번호 (Key) — Primary key — NOT NULL
- 부서명 (Field)
- 부서위치 (Field2)
EMP (Untitled2)
- 사원번호 (Key) — Primary key — NOT NULL
- 부서번호 (Key2) — Foreign key → DEPT.부서번호 — NOT NULL
- 사원명 (Field)
- 담당업무 (Field2)
- 매니저 (Field3)
- 입사일자 (Field4)
- 급여 (Field5)
- 보너스 (Field6)
- 부서번호 (Field7)
comments
- comment_id — INTEGER
- post_id — TEXT — Foreign key → posts.post_id
- author_id — TEXT — Foreign key → users.user_id
- content — TEXT — NOT NULL
- parent_id — INTEGER
- created_at — DATETIME
missions
- mission_id — INTEGER
- user_id — TEXT — Foreign key → users.user_id
- mission_title — TEXT — NOT NULL
- status — TEXT
- certified_post_id — TEXT — Foreign key → posts.post_id
- completed_at — DATETIME
post_images
- image_id — INTEGER
- post_id — TEXT — Foreign key → posts.post_id
- image_url — TEXT — NOT NULL
posts
- post_id — TEXT
- author_id — TEXT — Foreign key → users.user_id
- category — TEXT — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- view_count — INTEGER
- created_at — DATETIME
reactions
- reaction_id — INTEGER
- post_id — TEXT — Foreign key → posts.post_id
- user_id — TEXT — Foreign key → users.user_id
- reaction_type — TEXT
- created_at — DATETIME
- UNIQUE(post_id, — user_id,
users
- user_id — TEXT
- username — TEXT — NOT NULL
- password_hash — TEXT — NOT NULL
- nickname — TEXT — NOT NULL
- profile_image_url — TEXT
- career_goal — TEXT
- personality_type — TEXT
- suitability_json — TEXT
- created_at — DATETIME