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