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