IMMusic

Tables (5)

about

  • Key (id) — int — Primary key — NOT NULL
  • regDate — datetime
  • updateDate — datetime
  • 인사말 (greet) — text

artist

  • Key (id) — int — Primary key — NOT NULL
  • regDate — datetime
  • updateDate — datetime
  • name (artist_name) — char
  • birthday (artist_birth) — date
  • gender (artist_gender) — int
  • phone (artist_phone) — char
  • email (artist_email) — char
  • address (artist_address) — char
  • major (artist_major) — char
  • sns (artist_sns) — char
  • picture (artist_photo) — char
  • career (artist_career) — char
  • delete (delStatus) — int
  • delDate — datetime

contactUs

  • Key (id) — int — Primary key — NOT NULL
  • board (contact_board) — int
  • regDate — datetime
  • updateDate — datetime
  • name (contact_name) — char
  • birth — date
  • gender — int
  • phone — char
  • email — char
  • address — char
  • major — char
  • sns — char
  • photo — char
  • career — char
  • concert_date — datetime
  • concert_location — char
  • delete (delStatus) — int
  • delDate — datetime

contactUs (contactUs board)

  • Key (id) — int — Primary key — NOT NULL
  • regDate — datetime
  • updateDate — datetime
  • code — char
  • delete (delStatus) — int
  • delDate — datetime

press

  • Key (id) — int — Primary key — NOT NULL
  • regDate — datetime
  • updateDate — datetime
  • title — char
  • body — text
  • delete (delStatus) — int
  • delDate — datetime