dimelo
Tables (10)
courses
- id — INTEGER
- title — VARCHAR(255) — NOT NULL
- tutor — VARCHAR(100) — NOT NULL
- platform — VARCHAR(100) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- skill — VARCHAR(100) — NOT NULL
- price — INTEGER
- created_at — TIMESTAMP — NOT NULL
likes
- user_id — INTEGER — Primary key — NOT NULL
- course_id — INTEGER — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
projects
- id — INTEGER
- title — VARCHAR(100) — NOT NULL
- position — VARCHAR(100)
- skill — VARCHAR(100)
- content — TEXT
- ongoing — ENUM('모집중', '모집완료')
- duedate — DATETIME(6)
- participant — VARCHAR(10)
- user_id — INTEGER — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
projects_comments
- id — INTEGER
- comment_text — TEXT — NOT NULL
- user_id — INTEGER — NOT NULL
- project_id — INTEGER — NOT NULL
reviews
- id — INTEGER
- course_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- q1 — INTEGER
- q2 — INTEGER
- q3 — INTEGER
- q4 — INTEGER
- pros — TEXT
- cons — TEXT
- helped — INTEGER
- created_at — TIMESTAMP — NOT NULL
studies
- id — INTEGER
- title — VARCHAR(100) — NOT NULL
- skill — VARCHAR(100)
- content — TEXT
- ongoing — ENUM('모집중', '모집완료')
- duedate — DATETIME(6)
- participant — VARCHAR(10)
- user_id — INTEGER — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
studies_comments
- id — INTEGER
- comment_text — TEXT — NOT NULL
- user_id — INTEGER — NOT NULL
- study_id — INTEGER — NOT NULL
talks
- id — INTEGER
- category — ENUM('개발', '데이터', '디자인', '기타')
- title — VARCHAR(100)
- content — TEXT
- user_id — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
talks_comments
- id — INTEGER
- comment_text — TEXT — NOT NULL
- user_id — INTEGER — NOT NULL
- talk_id — INTEGER — NOT NULL
users
- id — INTEGER
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(255)
- job — VARCHAR(100)
- career — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP