GaesenakWeb DB - gaesenak/GaesenakWeb GitHub Wiki

CREATE SCHEMA `gaesenak` DEFAULT CHARACTER SET utf8 ;


-- -----------------------------------------------------
-- table `gaesenak`.`user`
-- -----------------------------------------------------
CREATE TABLE `user` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL COMMENT '가입 이메일',
  `password` varchar(20) NOT NULL COMMENT '비밀번호',
  `auth` varchar(10) NOT NULL DEFAULT 'user' COMMENT '권한',
  `profile` varchar(255) DEFAULT NULL COMMENT '프로필 사진',
  `nickname` varchar(20) NOT NULL COMMENT '활동 닉네임',
  `phone` varchar(11) DEFAULT NULL COMMENT '핸드폰 번호',
  `state` char(1) NOT NULL DEFAULT 'Y' COMMENT '상태 ( Y : 정상, S : 활동중지, N : 탈퇴 )',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '가입날짜',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '수정날짜',
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='회원 목록'