GGJ

Tables (12)

community_comments

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → community_posts.id — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

community_posts

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • image — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

contests

  • id — INT — Primary key — NOT NULL
  • ix — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • read_count — INT
  • img_src — VARCHAR(1000)
  • 분야 — VARCHAR(255)
  • 응모대상 — VARCHAR(255)
  • 주최_주관 — VARCHAR(255)
  • 후원_협찬 — VARCHAR(255)
  • 접수마감일 — DATE
  • 총_상금 — VARCHAR(100)
  • 일등_상금 — VARCHAR(100)
  • 홈페이지 — VARCHAR(1000)
  • 첨부파일 — VARCHAR(1000)
  • created_at — TIMESTAMP

daily_study_summary

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • study_date — DATE — NOT NULL
  • total_seconds — INT — NOT NULL

keyword_study_summary

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • total_seconds — INT — NOT NULL

portfolio

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • about — TEXT
  • profile_image — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

recruit_comments

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → recruit_posts.id — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

recruit_posts

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • thumbnail — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

timer_logs

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • duration_seconds — INT — NOT NULL
  • created_at — TIMESTAMP

user_projects

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT

user_skills

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • color — VARCHAR(30)

users

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP