-
Notifications
You must be signed in to change notification settings - Fork 0
/
DB_Creation.txt
67 lines (57 loc) · 3.02 KB
/
DB_Creation.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
/* DB 생성 */
CREATE DATABASE `toypro` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
-- toypro.t_bd_catg definition
CREATE TABLE `t_bd_catg` (
`SEQ` int(11) NOT NULL AUTO_INCREMENT COMMENT '일련번호',
`CATG_CD` varchar(10) DEFAULT NULL COMMENT '카테고리 코드',
`CATG_NM` varchar(50) DEFAULT NULL COMMENT '카테고리 이름',
`REG_DATE` date DEFAULT NULL COMMENT '등록일',
`UPDT_DATE` date DEFAULT NULL COMMENT '수정일',
PRIMARY KEY (`SEQ`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- toypro.t_bd_comm definition
CREATE TABLE `t_bd_comm` (
`SEQ` int(11) NOT NULL AUTO_INCREMENT COMMENT '일련번호',
`BOARD_CD` varchar(10) DEFAULT NULL COMMENT '게시판 글코드',
`COMM_SUBJECT` varchar(500) DEFAULT NULL COMMENT '댓글 내용',
`REG_DATE` date DEFAULT NULL COMMENT '등록일',
`UPDT_DATE` date DEFAULT NULL COMMENT '수정일',
PRIMARY KEY (`SEQ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- toypro.t_bd_table definition
CREATE TABLE `t_bd_table` (
`SEQ` int(11) NOT NULL AUTO_INCREMENT COMMENT '일련번호',
`BOARD_CD` varchar(20) DEFAULT NULL COMMENT '게시판글 코드',
`BOARD_TITLE` varchar(50) DEFAULT NULL COMMENT '게시판글 제목',
`BOARD_USER_NO` int(11) DEFAULT NULL COMMENT '게시판 유저번호',
`BOARD_CATG_CD` varchar(10) DEFAULT NULL COMMENT '카테고리 코드',
`BOARD_SUBJECT` longtext DEFAULT NULL COMMENT '게시판글 내용',
`BOARD_CNT` int(11) DEFAULT NULL COMMENT '게시판 조회수',
`reg_date` date DEFAULT NULL COMMENT '등록일',
`updt_date` date DEFAULT NULL COMMENT '수정일',
PRIMARY KEY (`SEQ`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- toypro.t_cddc_nm definition
CREATE TABLE `t_cddc_nm` (
`SEQ` int(11) NOT NULL AUTO_INCREMENT COMMENT '일련번호',
`CDDC_CD` varchar(100) DEFAULT NULL COMMENT '교육청코드',
`CDDC_NM` varchar(100) NOT NULL COMMENT '교육청명',
`ORDER_NUM` int(11) NOT NULL COMMENT '정렬번호',
`REG_DATE` date DEFAULT NULL COMMENT '생성일자',
`UPDT_DATE` date DEFAULT NULL COMMENT '수정일자',
PRIMARY KEY (`SEQ`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- toypro.t_toy_user definition
CREATE TABLE `t_toy_user` (
`NO` int(11) NOT NULL AUTO_INCREMENT COMMENT '회원번호',
`USER_ID` varchar(100) NOT NULL COMMENT '아이디',
`USER_PWD` varchar(100) DEFAULT NULL COMMENT '비밀번호',
`USER_NAME` varchar(100) NOT NULL COMMENT '이름',
`NICK_NAME` varchar(100) DEFAULT NULL COMMENT '닉네임',
`USER_EMAIL` varchar(100) DEFAULT NULL COMMENT '이메일',
`PHONE_NO` varchar(11) DEFAULT NULL COMMENT '전화번호',
`USER_TYPE` varchar(10) DEFAULT NULL COMMENT '계정 타입 0 : 유저 / 1 : 관리자',
`REG_DATE` date DEFAULT NULL COMMENT '등록일',
`UPDT_DATE` date DEFAULT NULL COMMENT '수정일',
PRIMARY KEY (`NO`,`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;