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