Test

Tables (4)

User (사용자)

  • id (아이디) — char — Primary key — NOT NULL
  • pwd (비밀번호) — char
  • email (이메일) — char

board (게시판)

  • id (아이디) — int — Primary key — NOT NULL
  • user (작성자) — char — Foreign key → User.id — NOT NULL
  • content (내용) — char
  • reg_time (등록시간) — date

comment (댓글)

  • id (아이디) — int — Primary key — NOT NULL
  • board (게시판) — int — Foreign key → board.id — NOT NULL
  • user (작성자) — char — Foreign key → board.user — NOT NULL
  • content (내용) — char
  • reg_time (등록시간) — date

feature (특징)

  • id (아이디) — int — Primary key — NOT NULL
  • user (유저 아이디) — char — Foreign key → User.id — NOT NULL
  • age (나이) — int
  • workclass (고용 형태) — char
  • fnlwgt (대표성) — float
  • education (교육 수준) — char
  • education_num (교육 수준 수치) — float
  • marital_status (결혼 상태) — char
  • occupation (업종) — char
  • relationship (가족 관계) — char
  • raced (인종) — char
  • sex (성별) — char
  • capital_gain (양도 소득) — int
  • capital_loss (양도 손실) — int
  • hours_per_week (주당 근무 시간) — int
  • native_country (국적) — char
  • income (수익) — float