웹 어플리케이션 제작에 필요한 기본 DB 구성

기본 db 세팅

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;