DB - gaesenak/web_boot GitHub Wiki

- -—————————————————————————-
- 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=‘회원 목록’

- -—————————————————————————-
- table `gaesenak`.`common`
- -—————————————————————————
CREATE TABLE `common` (
`id_cd` int(11) NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
`large_cd` char(5) NOT NULL COMMENT ‘대분류 코드’,
`small_cd` varchar(5) NOT NULL COMMENT ‘소분류 코드’,
`name_cd` varchar(255) NOT NULL COMMENT ‘코드명’,
`position` int(11) DEFAULT NULL COMMENT ‘위치순번’,
`sub1` varchar(255) DEFAULT NULL COMMENT ‘확장속성1’,
`sub2` varchar(255) DEFAULT NULL COMMENT ‘확장속성2’,
`sub3` varchar(255) DEFAULT NULL COMMENT ‘확장속성3’,
`sub4` varchar(255) DEFAULT NULL COMMENT ‘확장속성4’,
`sub5` varchar(255) DEFAULT NULL COMMENT ‘확장속성5’,
`del_yn` enum(‘Y’,‘N’) NOT NULL DEFAULT ‘N’ COMMENT ‘삭제여부’,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘생성일시’,
`created_user_id` int(11) NOT NULL COMMENT ‘생성자ID’,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘수정일시’,
`updated_user_id` int(11) NOT NULL COMMENT ‘수정자ID’,
PRIMARY KEY (`id_cd`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT=‘공통코드테이블’

- -—————————————————————————-
- table `gaesenak`.`board`
- -—————————————————————————
CREATE TABLE `board` (
`id_board` int(11) NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
`board_type` varchar(5) NOT NULL COMMENT ‘게시판 타입(AA001)’,
`title` varchar(255) NOT NULL COMMENT ‘제목’,
`content` text NOT NULL COMMENT ‘내용’,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘작성일시’,
`created_user_id` int(11) NOT NULL COMMENT ‘작성자ID’,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘수정일시’,
`updated_user_id` int(11) NOT NULL COMMENT ‘수정자ID’,
PRIMARY KEY (`id_board`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘게시판’