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)