gg

Tables (3)

myNameCard (Untitled2)

  • m_id (명함 id) — int — Primary key — NOT NULL
  • p_email (회원 id) — varchar(100) — Foreign key → user.p_email — NOT NULL
  • m_name (이름)
  • m_company (회사)
  • m_department (부서)
  • m_position (직급)
  • m_address (회사주소)
  • m_email (이메일)
  • m_number (전화번호)
  • m_Img (회사로고)

user (Untitled)

  • p_email (회원 id) — varchar(100) — Primary key — NOT NULL
  • p_gender (성별) — varchar(100)
  • p_name (이름) — varchar(100)
  • p_number (전화번호) — varchar(100)
  • p_pwd (비밀번호) — varchar(100)

yourNameCard (Untitled3)

  • y_id (명함 id) — int — Primary key — NOT NULL
  • p_email (회원 id) — varchar(100) — Foreign key → user.p_email — NOT NULL
  • y_name (이름)
  • y_company (회사)
  • y_department (부서)
  • y_position (직급)
  • y_address (회사주소)
  • y_email (이메일)
  • y_number (전화번호)
  • y_Img (회사로고)