테스트

테이블 (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