Jasoseol

Tables (11)

chatmessage (Untitled6)

  • chatmessage_id (Key) — bigint — Primary key — NOT NULL
  • chatroom_id (Key2) — bigint — Foreign key → chatroom.chatroom_id — NOT NULL
  • user_id (Field) — bigint
  • nickname (Field3) — varchar
  • content (Field2) — varchar

chatroom (Untitled4)

  • chatroom_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar

comment (댓글)

  • comment_id — bigint — Primary key — NOT NULL
  • free_post_id (board_id) — bigint — Foreign key → free_post.free_post_id — NOT NULL
  • content — varchar — NOT NULL

enterprise (Untitled2)

  • enterprise_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar — NOT NULL
  • description (Field2) — varchar

free_post (자유게시판)

  • free_post_id (board_id) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL
  • title — varchar — NOT NULL
  • content — varchar — NOT NULL

profile (Untitled3)

  • profile_id (Key) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL
  • name (Field2) — varchar
  • introduction (Field) — varchar

recruitment (채용공고)

  • recruitment_id — bigint — Primary key — NOT NULL
  • enterprise_id (Key) — bigint — Foreign key → enterprise.enterprise_id — NOT NULL
  • title — varchar — NOT NULL
  • content — varchar — NOT NULL

resume (이력서)

  • resume_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL
  • enterprise_id (Key) — bigint — Foreign key → enterprise.enterprise_id — NOT NULL
  • title (Field2) — varchar — NOT NULL
  • content (Field) — varchar — NOT NULL

s3file (Untitled)

  • file_id (Key) — bigint — Primary key — NOT NULL
  • resume_id — bigint — Foreign key → resume.resume_id — NOT NULL
  • recruitment_id — bigint — Foreign key → recruitment.recruitment_id — NOT NULL
  • enterprise_id (Key2) — bigint — Foreign key → enterprise.enterprise_id — NOT NULL
  • filename (Field) — varchar — NOT NULL

user (사용자)

  • user_id — bigint — Primary key — NOT NULL
  • username — varchar — NOT NULL
  • password — varchar — NOT NULL
  • nickname (Field3) — varchar
  • account_type (Field) — varchar — NOT NULL
  • signup_type (Field2) — varchar — NOT NULL

user_chatroom (Untitled5)

  • user_chatroom_id (Key) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL
  • chatroom_id (Key2) — bigint — Foreign key → chatroom.chatroom_id — NOT NULL