서버정보

• host : matsulang.cwgugsk0vnht.ap-northeast-2.rds.amazonaws.com
• ID : admin
• PW : !mgrsol123
• Port : 3306

User

DROP TABLE IF EXISTS user_tb; CREATE TABLE IF NOT EXISTS user_tb ( user_idx INT NOT NULL AUTO_INCREMENT, user_id VARCHAR(20) NOT NULL UNIQUE, user_password VARCHAR(50) NOT NULL, user_name VARCHAR(20) NOT NULL, user_nickname VARCHAR(50) NOT NULL, user_gender CHAR(1) NOT NULL, user_ntrp DECIMAL(2,1) NOT NULL, user_photo_path VARCHAR(100) NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL, use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (user_idx) );

DROP TABLE IF EXISTS login_history_tb; CREATE TABLE IF NOT EXISTS login_history_tb ( user_idx INT NOT NULL AUTO_INCREMENT, ip_address VARCHAR(16) NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), PRIMARY KEY (user_idx, ip_address, create_dt) );

Board

DROP TABLE IF EXISTS board_tb; CREATE TABLE IF NOT EXISTS board_tb( board_idx INT NOT NULL AUTO_INCREMENT, writer_idx INT NOT NULL, board_title VARCHAR(200), board_contents TEXT NOT NULL, board_type CHAR(2) NOT NULL, wanted_cnt INT, wanted_comp CHAR(1) NOT NULL DEFAULT 'N', upload_file_path TEXT, create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL DEFAULT NOW(), use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (board_idx) );

DROP TABLE IF EXISTS board_reply_tb; CREATE TABLE IF NOT EXISTS board_reply_tb( board_reply_idx INT NOT NULL, board_idx INT NOT NULL, writer_idx INT NOT NULL, reply_contents TEXT NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL DEFAULT NOW(), use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (board_reply_idx) );

DROP TABLE IF EXISTS board_upl_tb; CREATE TABLE IF NOt EXISTS board_upl_tb( board_upl_idx INT NOT NULL AUTO_INCREMENT, board_idx INT NOT NULL, upl_path VARCHAR(200) NOT NULL, create_dt DATETIME NOT NULL, use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (board_upl_idx) );

Club

DROP TABLE IF EXISTS club_tb; CREATE TABLE IF NOT EXISTS club_tb( club_idx INT NOT NULL AUTO_INCREMENT, club_nm VARCHAR(20), club_info TEXT NOT NULL, club_location VARCHAR(20) NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL DEFAULT NOW(), use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (club_idx) );

DROP TABLE IF EXISTS club_join_tb; CREATE TABLE IF NOT EXISTS club_join_tb( club_join_idx INT NOT NULL AUTO_INCREMENT, club_idx INT NOT NULL, user_idx INT NOT NULL, club_grade VARCHAR(20) NOT NULL DEFAULT 'COMMON', create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL DEFAULT NOW(), use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (club_join_idx) );

DROP TABLE IF EXISTS club_board_tb; CREATE TABLE IF NOT EXISTS club_board_tb( club_board_idx INT NOT NULL AUTO_INCREMENT, club_idx INT NOT NULL, writer_idx INT NOT NULL, club_board_type CHAR(2) NOT NULL, club_board_title VARCHAR(200), club_board_contents TEXT NOT NULL, wanted_cnt INT NOT NULL, wanted_comp CHAR(1) NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL DEFAULT NOW(), use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (club_board_idx) );

DROP TABLE IF EXISTS club_board_reply_tb; CREATE TABLE IF NOT EXISTS club_board_reply_tb( club_board_reply_idx INT NOT NULL AUTO_INCREMENT, board_idx INT NOT NULL, writer_idx INT NOT NULL, reply_contents TEXT NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), update_dt DATETIME NOT NULL DEFAULT NOW(), PRIMARY KEY (club_board_reply_idx) );

DROP TABLE IF EXISTS club_board_upl_tb; CREATE TABLE IF NOt EXISTS club_board_upl_tb( club_board_upl_idx INT NOT NULL AUTO_INCREMENT, club_board_idx INT NOT NULL, upl_path VARCHAR(200) NOT NULL, create_dt DATETIME NOT NULL, use_yn CHAR(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (club_board_upl_idx) );

Match

DROP TABLE IF EXISTS ath_match_tb; CREATE TABLE IF NOT EXISTS ath_match_tb( club_board_idx INT NOT NULL, owner_idx INT NOT NULL, match_type CHAR(1) NOT NULL, user_cnt INT NOT NULL, game_cnt INT NOT NULL, court_cnt INT NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), PRIMARY KEY (club_board_idx) );

DROP TABLE IF EXISTS club_board_join_tb; CREATE TABLE IF NOT EXISTS club_board_join_tb( club_board_join_idx INT NOT NULL AUTO_INCREMENT, club_board_idx INT NOT NULL, user_idx INT NOT NULL, create_dt DATETIME NOT NULL DEFAULT NOW(), PRIMARY KEY (club_board_join_idx) );

DROP TABLE IF EXISTS ath_game_tb; CREATE TABLE IF NOT EXISTS ath_game_tb( ath_game_idx INT NOT NULL AUTO_INCREMENT, ath_match_idx INT NOT NULL, host_idx1 INT NOT NULL, host_idx2 INT, guest_idx1 INT NOT NULL, guest_idx2 INT, court_sequence INT NOT NULL, host_score INT NOT NULL DEFAULT -1, guest_score INT NOT NULL DEFAULT -1, PRIMARY KEY (ath_game_idx) );