chCruit
Tables (12)
article_tags (Untitled5)
- Key (article_tag_id) — NOT NULL — Primary key — NOT NULL
- Key (article_id) — NOT NULL — Foreign key → articles.member_uuid — NOT NULL
articles (Untitled)
- member_uuid — NOT NULL — Primary key — NOT NULL
- article_type — ENUM('FREE','JOBWANT','WORKERWANT','EXPIRED')
- recruit_volume — NULL
- title — NOT NULL
- content — NOT NULL
- qualification_detail — NULL
- duration (contract_duration) — ENUM('SHORT','MID','LONG','PROJECTBYPROJECT') , NULL
- location (work_location) — ENUM('HOME','COMPANY','BLENDING')
- pay — NULL
- source (video_source_url) — NULL
- contact — NOT NULL
- created_at — NULL
- Key (member_id) — NOT NULL — Foreign key → member.Key — NOT NULL
- member_key — NOT NULL
chat_content (Untitled9)
- Key (content_id) — NOT NULL — Primary key — NOT NULL
- message — NOT NULL
- send_at — NULL
- type (message_type) — ENUM('TEXT','IMAGE','FILE')
- file_name (original_file_name) — NULL
- Key (chatroom_id) — NOT NULL — Foreign key → chatroom.Key — NOT NULL
- Key (sender_id) — NOT NULL — Foreign key → member.Key — NOT NULL
chat_participant (Untitled12)
- Key (chatmember_id) — NOT NULL — Primary key — NOT NULL
- join (joined_at) — NULL
- is_exit — NOT NULL
- Key (member_id2) — NOT NULL — Foreign key → member.Key — NOT NULL
- Key (last_read_content_id) — NOT NULL — Foreign key → chat_content.Key — NOT NULL
- Key (chatroom_id) — NOT NULL — Foreign key → chatroom.Key — NOT NULL
chatroom (Untitled8)
- Key (chatroom_id) — NOT NULL — Primary key — NOT NULL
- created_at — NULL
- Key (article_id) — NOT NULL — Foreign key → articles.member_uuid — NOT NULL
- Key (participant_id1) — NOT NULL — Foreign key → member.Key — NOT NULL
- Key (participant_id2) — NOT NULL — Foreign key → member.Key — NOT NULL
cruit (Untitled11)
- Key (cruit_id) — NOT NULL — Primary key — NOT NULL
- status (application_status) — ENUM('ACCEPTED','REJECTED','WAITING','DISCUSSING')
- Field (update_at) — NULL
- Field (created_at) — NULL
- Key (member_id) — NOT NULL — Foreign key → member.Key — NOT NULL
- Key (articles_id) — NOT NULL — Foreign key → articles.member_uuid — NOT NULL
member
- Key (member_id) — NOT NULL — Primary key — NOT NULL
- nickname — NOT NULL
- type (member_type) — NOT NULL
- profile (profile_img_url) — NOT NULL
- email — NOT NULL
- pw (password) — NOT NULL
- pw_expired (password_last_expired) — NOT NULL
- pw_last (password_last) — NOT NULL
- created_at — NULL
- create_ip — NULL
- provider — ENUM('LOCAL','NAVER','GOOGLE')
- social_id — NULL
member_status (Untitled2)
- Key (status_id) — NOT NULL — Primary key — NOT NULL
- status — ENUM('ACTIVE','BANNED','WITHDRAW','WAITFORBAN')
- role — ENUM('ROLE_USER','ROLE_ADMIN')
- last_login (last_login_at) — NULL
- Key (member_id) — NOT NULL — Foreign key → member.Key — NOT NULL
portfolio_file (Untitled7)
- Key (file_id) — NOT NULL — Primary key — NOT NULL
- file_path — NOT NULL
- file_ext — NOT NULL
- original_file_name — NOT NULL
- file_size — NOT NULL
- created_at — NULL
- Key (member_id) — NOT NULL — Foreign key → member.Key — NOT NULL
profile (Untitled10)
- Key (profile_id) — NOT NULL — Primary key — NOT NULL
- visible — NOT NULL
- notification_setting — NOT NULL
- Key (member_id) — NOT NULL — Foreign key → member.Key — NOT NULL
sample_files (CopyOfUntitled7)
- Key (file_id) — NOT NULL — Primary key — NOT NULL
- file_path — NOT NULL
- file_ext — NOT NULL
- original_file_name — NOT NULL
- file_size — NOT NULL
- file_type (content_type) — NOT NULL
- created_at — NULL
- Key (articles_id) — NOT NULL — Foreign key → articles.member_uuid — NOT NULL
tags (Untitled3)
- Key (tags_id) — NOT NULL — Primary key — NOT NULL
- tag — ENUM('VIDEO_EDITOR','THUMBNAILER','MANAGER','ETC') , NULL
- ETC (etc_detail) — NULL
- Key (article_tag_id) — NOT NULL — Foreign key → article_tags.Key — NOT NULL