pro p.f
Tables (10)
C_Comment (커뮤니티_댓글)
- cc_seq (Key) — Primary key — NOT NULL
- cc_comment (Field)
- cc_date (Field2)
- cc_like (Field3)
Community (커뮤니티)
- c_seq (Key) — Primary key — NOT NULL
- m_id (Key2) — Foreign key → Member.m_id — NOT NULL
- c_title (Field)
- c_date (Field2)
- c_like (Field3)
- c_category (Field4)
- c_date (Field5)
Company (회사회원)
- cy_id (Key) — Primary key — NOT NULL
- cy_pw (Field7)
- cy_num (Field8)
- cy_name (Field3)
- cy_m_name (Field9)
- cy_m_email (Field4)
- cy_m_phone (Field10)
- cy_intro (Field)
- cy_link (Field2)
- cy_img (Field5)
- cy_location (Field6)
Job (공고)
- j_seq (Key) — Primary key — NOT NULL
- cy_id (Key2) — Foreign key → Company.cy_id — NOT NULL
- j_name (Field2)
- j_date (Field3)
- j_person (Field4)
- j_target (Field5)
- j_area (Field6)
- j_content (Field7)
- j_scrap (Field8)
Like
- l_like (Key) — Primary key — NOT NULL
- p_seq (Key2) — Foreign key → Post.p_seq — NOT NULL
- m_id (Key3) — Foreign key → Member.m_id — NOT NULL
Member (회원)
- m_id (Key) — Primary key — NOT NULL
- m_pw (Field6)
- m_name (Field)
- m_phone (Field2)
- m_email (Field3)
- m_github (Field4)
P_Comment (포스팅 댓글_보류)
- pc_comment (Field)
- pc_date (Field2)
- pc_like (Field3)
Post (포스팅)
- p_seq (Key) — Primary key — NOT NULL
- m_id (Key2) — Foreign key → Member.m_id — NOT NULL
- s_seq (Key3) — Foreign key → Series.s_seq — NOT NULL
- p_ title (Field)
- p_content (Field2)
- p_like (Field3)
- p_img (Field4)
- p_view (Field5)
- p_scrap (Field7)
- p_date (Field6)
Resume (이력서_DB보류)
- r_seq (Key) — Primary key — NOT NULL
- r_add (Field)
- r_school (Field2)
- r_career (Field3)
- r_project (Field4)
- r_award (Field5)
- r_skill (Field6)
- r_intro (Field7)
Series (시리즈)
- s_seq (Key) — Primary key — NOT NULL
- m_id (Key2) — Foreign key → Member.m_id — NOT NULL
- s_name (Field)
- s_intro (Field2)
- s_date (Field3)