IMMusic Project(8) - DB 생성

• 연주자 가입신청 레이아웃 구현중
• DB스키마 생성 및 수정

# artist 테이블 추가
CREATE TABLE artist (
  id INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, # 번호
  a_name CHAR(10) NOT NULL,
  a_birth CHAR(10) NOT NULL,
  a_gender TINYINT(1) NOT NULL, # 1=남성, 2=여성
  a_phone CHAR(10) NOT NULL, 
  a_email CHAR(10) NOT NULL, 
  a_address CHAR(255) NOT NULL, 
  a_major CHAR(10) NOT NULL, 
  a_sns CHAR(50) NOT NULL, 
  a_photo CHAR(255) NOT NULL,
  a_career CHAR(255) NOT NULL,
  a_introduction TEXT NOT NULL,
  a_check TINYINT(1) UNSIGNED NOT NULL, # 개인정보 동의(0:비동의,1:동의)
  regDate DATETIME DEFAULT NULL, # 작성날짜
  updateDate DATETIME DEFAULT NULL, # 갱신날짜
  delStatus TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, # 삭제상태(0:미삭제,1:삭제)
  delDate DATETIME DEFAULT NULL # 삭제날짜
);

• 연주자 가입신청 

CREATE TABLE concert (
  id INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, # 번호
  c_name CHAR(10) NOT NULL,
  c_email CHAR(10) NOT NULL,
  c_phone CHAR(10) NOT NULL,
  c_date CHAR(10) NOT NULL, 
  c_address CHAR(10) NOT NULL, 
  c_inquiry TEXT NOT NULL,
  c_check TINYINT(1) UNSIGNED NOT NULL, # 개인정보 동의(0:비동의,1:동의)
  regDate DATETIME DEFAULT NULL, # 작성날짜
  updateDate DATETIME DEFAULT NULL, # 갱신날짜
  delStatus TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, # 삭제상태(0:미삭제,1:삭제)
  delDate DATETIME DEFAULT NULL # 삭제날짜
);

• 연주문의

📝 8일차 회의록

https://docs.google.com/document/d/1XugOuN7oE3sMwveTsbuUWcpDiIqY9dB2RI8sHNHqJAk/edit#heading=h.lntg56ljm653