Test
Tables (12)
apply_tb
- apply_id — int — Primary key — NOT NULL
- apply_result — boolean — 합격 true, 불합격 fasle , 미정 null
- member_id — varchar(20) — NOT NULL
- recruit_id — int — NOT NULL
- apply_created_at — datetime — NOT NULL
bookmark
- recruit_id — int — Foreign key → recruit_tb.recruit_id — NOT NULL
- member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
- bookmark_created_at — datetime — NOT NULL
community_article_tb
- article_id — int — Primary key — NOT NULL
- article_title — varchar(50) — NOT NULL
- article_content — varchar(2048)
- member_id — varchar(20) — NOT NULL
- article_created_at — datetime — NOT NULL
community_like_tb
- article_id — int — Foreign key → community_article_tb.article_id — NOT NULL
- member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
- like_created_at — datetime — NOT NULL
community_reply_tb
- reply_id — int — Primary key — NOT NULL
- reply_content — varchar(128)
- article_id — int — NOT NULL
- member_id — varchar(20) — NOT NULL
- reply_created_at — datetime — NOT NULL
img_tb
- member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
- img_location — varchar(128) — NOT NULL
- img_filename — varchar(128) — NOT NULL
- img_filetype — varchar(10) — NOT NULL
- img_updated_at — datetime — NOT NULL
member_tb
- member_id — varchar(20) — Primary key — NOT NULL
- member_pw — varchar(128) — NOT NULL
- member_name — varchar(20) — NOT NULL
- member_birth — date — NOT NULL
- member_gender — char(1) — 기업회원은 NULL
- member_phone — varchar(12) — NOT NULL
- member_addr — varchar(256)
- member_coord_x — float — 위도 (일반회원은 NULL)
- member_coord_y — float — 경도 (일반회원은 NULL)
- member_nickname — varchar(20) — NOT NULL
- member_email — varchar(128) — NOT NULL
- member_type — char(1) — NOT NULL — 일반회원 N, 기업회원 C, 관리자 A
- member_reg_num — varchar(32) — 일반회원은 NULL
- member_info — varchar(512)
- member_active — boolean — true면 활성 회원. false면 탈퇴
- member_created_at — datetime
- work_area_id — int — NOT NULL
- member_verified — boolean — 일반회원은 NULL가능. 다만 이후 이메일인증 사용시 이 필드 활용 가능
notification_tb
- notification_id — int — Primary key — NOT NULL
- member_id — varchar(20) — NOT NULL
- suggest_id — int — NOT NULL — 둘 중에 NULL이 아닌 것에 대해 처리
- apply_id — int — NOT NULL
- notification_created_at — datetime — NOT NULL
recruit_tb
- recruit_id — int — Primary key — NOT NULL
- company_id — varchar(20) — NOT NULL
- recruit_title — varchar(36) — NOT NULL
- recruit_detail — varchar(1024)
- work_area_id — int — NOT NULL
- recruit_start_at — datetime — NOT NULL
- recruit_end_at — datetime — NOT NULL
- recruit_expose — boolean
resume_tb
- member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
- resume_location — varchar(128) — NOT NULL
- resume_filename — varchar(128) — NOT NULL
- resume_filetype — varchar(10) — NOT NULL
- resume_updated_at — datetime — NOT NULL
- resume_open — boolean — NOT NULL
suggest_tb
- suggest_id — int — Primary key — NOT NULL
- suggest_created_at — datetime — NOT NULL
- company_id — varchar(20) — NOT NULL
- member_id — varchar(20) — NOT NULL
work_area_tb
- work_area_id — int — Primary key — NOT NULL
- work_area_name — varchar(32) — NOT NULL
- work_area_comment — varchar(256) — NOT NULL