sunday_0428
Tables (13)
alert
- id — VARCHAR(255)
- sender_id — VARCHAR(255) — NOT NULL
- receiver_id — VARCHAR(255) — NOT NULL
- message — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
ongoing_project
- id — BIGINT
- project_id — BIGINT — NOT NULL
- team_leader_id — VARCHAR(255) — NOT NULL
- status — ENUM('ONGOING', 'COMPLETED', 'CANCELLED') — NOT NULL
- start_date — DATE
- end_date — DATE
ongoing_project_member
- id — BIGINT
- ongoing_project_id — BIGINT — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- role — VARCHAR(255)
peer_review
- project_id — BIGINT — Primary key — NOT NULL
- reviewer_id — VARCHAR(255) — Primary key — NOT NULL
- reviewee_id — VARCHAR(255) — Primary key — NOT NULL
- stars — ENUM('1', '2', '3', '4', '5') — NOT NULL
- comment — TEXT — EX
- comment_auth — ENUM('free', 'plus') — NOT NULL
portfolio
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
- from_here — BOOLEAN — NOT NULL
profile
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- gender — ENUM('MALE', 'FEMALE')
- age — INT
- skill_level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED')
- experience_years — INT
- desired_type — ENUM('대면', '비대면', '상관없음')
- residence_area — VARCHAR(255)
- desired_job — VARCHAR(255)
- personality — TEXT
- project_id — BIGINT
- self_intro — TEXT
- main_url — VARCHAR(255)
project
- id — BIGINT
- owner_id — VARCHAR(255) — NOT NULL
- domain — ENUM('개발', '예술') — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- type — ENUM('팀프로젝트') — NOT NULL
- location_type — ENUM('대면', '비대면') — NOT NULL
- duration_weeks — INT
- team_size — INT
- require_tag — VARCHAR(255)
- require_text — TEXT
- created_at — DATETIME — NOT NULL
project_application
- id — BIGINT
- project_id — BIGINT — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
- message — TEXT
- created_at — DATETIME — NOT NULL
project_tag
- project_id — BIGINT
- tag_id — BIGINT
report
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- project_id — BIGINT
- message_id — BIGINT
- status — ENUM('신고대기', '처리완료', '거부') — NOT NULL
- report_reason — ENUM('욕설', '광고', '도배', '기타') — NOT NULL
tag
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
user_account
- user_id — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- provider — ENUM('github', 'kakao') — NOT NULL
- role — ENUM('user', 'admin') — NOT NULL
- banned — BOOLEAN — NOT NULL
user_tag
- user_id — VARCHAR(255)
- tag_id — BIGINT