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