Knoc
Tables (12)
CHAT_MESSAGE
- id — BIGINT
- chat_room_id — BIGINT — Foreign key → CHAT_ROOM.id — NOT NULL
- sender_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- message_type — ENUM('TEXT', 'ORDER', 'REVIEW_REQUEST', 'REVIEW_REPORT') — NOT NULL
- content — TEXT
- reference_id — BIGINT
- created_at — DATETIME — NOT NULL
CHAT_ROOM
- id — BIGINT
- junior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- senior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- status — ENUM('ACTIVE', 'CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
- closed_at — DATETIME
EMAIL_VERIFICATION
- id — BIGINT
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- company_email — VARCHAR(255) — NOT NULL
- verification_code — VARCHAR(10) — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- expired_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
MEMBER
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- role — ENUM('USER', 'SENIOR') — NOT NULL
- profile_image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ORDERS
- id — BIGINT
- order_number — VARCHAR(100) — NOT NULL
- chat_room_id — BIGINT — Foreign key → CHAT_ROOM.id — NOT NULL
- junior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- senior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- amount — INT — NOT NULL
- status — ENUM('PENDING', 'PAID', 'SETTLED', 'CANCELLED') — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
REVIEW_FEEDBACK
- id — BIGINT
- order_id — BIGINT — Foreign key → ORDERS.id — NOT NULL
- junior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- senior_profile_id — BIGINT — Foreign key → SENIOR_PROFILE.id — NOT NULL
- rating — TINYINT — NOT NULL
- comment — TEXT — EX
- created_at — DATETIME — NOT NULL
REVIEW_REPORT
- id — BIGINT
- review_request_id — BIGINT — Foreign key → REVIEW_REQUEST.id — NOT NULL
- senior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- industry_perspective — TEXT
- edge_cases — TEXT
- alternatives — TEXT
- ai_summary — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
REVIEW_REQUEST
- id — BIGINT
- order_id — BIGINT — Foreign key → ORDERS.id — NOT NULL
- github_pr_url — VARCHAR(500) — NOT NULL
- project_context — TEXT
- concern_point — TEXT
- ai_pr_summary — TEXT
- created_at — DATETIME — NOT NULL
SENIOR_CAREER
- id — BIGINT
- senior_profile_id — BIGINT — Foreign key → SENIOR_PROFILE.id — NOT NULL
- company_name — VARCHAR(255) — NOT NULL
- position — VARCHAR(255) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
SENIOR_PROFILE
- id — BIGINT
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- company — VARCHAR(255)
- position — VARCHAR(255)
- career_years — INT
- introduction — TEXT
- linkedin_url — VARCHAR(500)
- price_per_review — INT — NOT NULL
- avg_rating — DECIMAL(3, 2) — NOT NULL
- total_review_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
SENIOR_SKILL
- id — BIGINT
- senior_profile_id — BIGINT — Foreign key → SENIOR_PROFILE.id — NOT NULL
- skill_name — VARCHAR(100) — NOT NULL
SETTLEMENT
- id — BIGINT
- order_id — BIGINT — Foreign key → ORDERS.id — NOT NULL
- senior_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- amount — INT — NOT NULL
- status — ENUM('PENDING', 'COMPLETED') — NOT NULL
- settled_at — DATETIME