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