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 (회사로고)