BaseAll

Tables (6)

Amenity (부대시설)

  • store_id (가게ID) — CHAR(10) — Primary key — NOT NULL
  • store_name (가게 이름) — VAHRCHAR(20) — NOT NULL
  • coordinate (가게 좌표) — VARCHAR(100) — NOT NULL
  • goods (상품) — VARCHAR(100) — NOT NULL
  • team_id (구단ID) — INT — Foreign key → Team.team_id — NOT NULL

Community (커뮤니티)

  • board_id (게시판ID) — CHAR(10) — Primary key — NOT NULL
  • team_id (구단ID) — INT — Foreign key → Team.team_id — NOT NULL
  • board_name (게시판 이름) — VARCHAR(20) — NOT NULL

Game (경기)

  • game_id (경기ID) — VARCHAR(10) — Primary key — NOT NULL
  • game_date (경기 날짜) — DATE — NOT NULL
  • price (티켓 가격) — INT — NOT NULL
  • home_team_id (홈 구단) — INT — Foreign key → Team.team_id — NOT NULL
  • away_team_id (원정 구단) — INT — Foreign key → Team.team_id — NOT NULL

Team (구단)

  • team_id (구단ID) — INT — Primary key — NOT NULL
  • team_name (구단이름) — CHAR(20) — NOT NULL
  • locataion (구단위치) — CHAR(10) — NOT NULL
  • phone (구단 연락처) — CAHR(15) — NOT NULL
  • year (설립 연도) — DATE — NOT NULL
  • team_img (구단 로고 이미지) — BLONG — NOT NULL

Ticket (티켓예매)

  • purchase_id (구매ID) — CHAR(10) — Primary key — NOT NULL
  • price (가격) — INT — NOT NULL
  • purchase_date (구매날짜) — DATE — NOT NULL
  • start_date (구매 시작 날짜) — DATE — NOT NULL
  • end_date (구매 마감 날짜) — DATE — NOT NULL
  • team_id (구단ID) — INT — Foreign key → Team.team_id — NOT NULL
  • user_id (구매자ID) — VARCHAR(20) — Foreign key → User.user_id — NOT NULL
  • game_id (경기ID) — VARCHAR(10) — Foreign key → Game.game_id — NOT NULL

User (사용자)

  • user_id (사용자ID) — VARCHAR(20) — Primary key — NOT NULL
  • password (비밀번호) — VARCHAR(20) — NOT NULL
  • user_name (사용자 이름) — VARCHAR(10) — NOT NULL
  • nickname (닉네임) — VARCHAR(10)
  • email (사용자 이메일) — VARCHAR(30) — NOT NULL
  • profile_img (사용자 사진) — BLONG
  • reg_date (회원가입날짜) — DATE — NOT NULL
  • team_id (구단ID) — INT — Foreign key → Team.team_id — NOT NULL