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
| create database angular;
use angular;
CREATE TABLE `tb_airport` (
`AIRPORT_ID` int(11) NOT NULL AUTO_INCREMENT,
`AIRPORT_NM` varchar(45) DEFAULT NULL,
`CONTINENT` varchar(45) DEFAULT NULL,
`NATION` varchar(45) DEFAULT NULL,
`CITY` varchar(45) DEFAULT NULL,
PRIMARY KEY (`AIRPORT_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
CREATE TABLE `tb_ticket` (
`TICKET_ID` int(11) NOT NULL AUTO_INCREMENT,
`TICKET_NM` varchar(100) DEFAULT NULL,
`TICKET_PRICE` int(11) DEFAULT NULL,
`TICKET_DEPARTURE` varchar(45) DEFAULT NULL,
`TICKET_ARRIVAL` varchar(45) DEFAULT NULL,
`TICKET_DEPARTURE_TIME` varchar(45) DEFAULT NULL,
`TICKET_ARRIVAL_TIME` varchar(45) DEFAULT NULL,
`TICKET_DEPARTURE_DT` varchar(45) DEFAULT NULL,
`TICKET_ARRIVAL_DT` varchar(45) DEFAULT NULL,
`CRE_DT` varchar(45) DEFAULT NULL,
PRIMARY KEY (`TICKET_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
CREATE TABLE `tb_usage` (
`USAGE_ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_EMAIL` varchar(45) DEFAULT NULL,
`USER_NM` varchar(45) DEFAULT NULL,
`USER_ENG_NM` varchar(45) DEFAULT NULL,
`USAGE_PHONE` varchar(45) DEFAULT NULL,
`USAGE_ENTITY` int(11) DEFAULT NULL,
`USAGE_STATUS` varchar(6) DEFAULT NULL COMMENT '003001 신청완료(입금대기)\n003002 입금완료\n003003 환불대기\n003004 환불완료\n003005 종료',
`USAGE_NATION` varchar(45) DEFAULT NULL COMMENT '도착 국가',
`USAGE_CITY` varchar(45) DEFAULT NULL,
`USAGE_DEPARTURE_CITY` varchar(45) DEFAULT NULL COMMENT '출발 도시',
`USAGE_DEPARTURE_DT` varchar(45) DEFAULT NULL,
`USAGE_ARRIVAL_DT` varchar(45) DEFAULT NULL COMMENT '도착일',
`USAGE_MEMO` text,
`CRE_DT` varchar(45) DEFAULT NULL,
PRIMARY KEY (`USAGE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
CREATE TABLE `tb_wishlist` (
`WL_ID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `tb_user` (
`USER_EMAIL` varchar(100) CHARACTER SET latin1 NOT NULL,
`USER_PWD` varchar(100) DEFAULT NULL,
`USER_TYPE` varchar(6) DEFAULT NULL COMMENT '002001 일반 회원\n002002 어드민\n',
`USER_NM` varchar(45) DEFAULT NULL,
`USER_ENG_NM` varchar(45) DEFAULT NULL,
`USER_GENDER` varchar(45) DEFAULT NULL,
`USER_BIRTHDAY` varchar(100) DEFAULT NULL,
`USER_PHONE` varchar(45) DEFAULT NULL,
`USER_USING_FREQ` int(11) DEFAULT NULL,
`CRE_DT` varchar(45) DEFAULT NULL,
PRIMARY KEY (`USER_EMAIL`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|