테스트
테이블 (15)
cancel
- cancel_no — int
- order_no — int
- item_no — int — NOT NULL
comment
- comment_no — int — 기본 키 — NOT NULL
- email — varchar(225)
- published — timestamp
- content — text
- game_id — int — NOT NULL
coupon
- coupon_no — int
- content — varchar(225)
- discount — int
- member_no — int
favorite_game
- member_no — int
- game_id — int — NOT NULL
file
- file_no — int — 기본 키 — NOT NULL
- original — varchar(255)
- real — varchar(255)
- uploaded — timestamp
- qna_no — int — NOT NULL
game
- game_id — int — 기본 키 — NOT NULL
- game_name — varchar(255)
- country1_name — varchar(100)
- country2_name — varchar(100)
- game_time — timestamp
- content — text
- stadium_name — varchar(255) — NOT NULL
- sport_id — int — NOT NULL
- country1_flag — varchar(255)
- country2_flag — varchar(255)
item
- item_no — int — 기본 키 — NOT NULL
- a_seat_sold — int
- b_seat_sold — int
- c_seat_sold — int
- d_seat_sold — int
- vip_seat_sold — int
- state — boolean
- is_korean — boolean
- game_id — int — NOT NULL
member
- member_no — int
- email — varchar(225)
- pwd — varchar(225)
- name — varchar(255)
- phone — varchar(225)
- birthday — varchar(255)
- create — timestamp
- membership — varchar(225)
- point — int
- state — int
order
- order_no — int
- Field — int
- buy_date — timestamp
- cancel_state — int
- member_no — int
- item_no — int — NOT NULL
play_game
- game_id — int — NOT NULL
- player_no — int — NOT NULL
player
- player_no — int — 기본 키 — NOT NULL
- player_name — varchar(255) — 팀인 경우 팀 정보 작성
- major — varchar(255)
- country — varchar(100)
- profile — varchar(255)
- birth — timestamp
- competed — int
qna
- qna_no — int — 기본 키 — NOT NULL
- writer — varchar(225)
- regdate — timstamp
- type — int
- content — text
- state — int
- title — varchar(255)
- readcnt — int
- game_id — int — NOT NULL
sport
- sport_id — int — 기본 키 — NOT NULL
- sport_name — varchar(255)
- title_image_url — varchar(255)
- content — text
- link — varchar(255)
stadium
- stadium_name — varchar(255) — 기본 키 — NOT NULL
- stadium_position — varchar(255)
- a_seat_price — int
- a_seat_quantity — int
- b_seat_price — int
- b_seat_quantity — int
- c_seat_price — int
- c_seat_quantity — int
- d_seat_price — int
- d_seat_quantity — int
- vip_seat_price — int
- vip_seat_quantity — int
std_game
- game_id — int — 기본 키 — NOT NULL
- game_name — varchar(255)
- country1_name — varchar(100)
- country2_name — varchar(100)
- game_time — timestamp
- stadium_name — varchar(255)
- sport_id — int — NOT NULL
- country1_flag — varchar(255)
- country2_flag — varchar(255)
- std_date — timestamp