ssg
Tables (4)
game (경기)
- date (날짜) — DATETIME — Primary key — NOT NULL
- teamseq (팀 번호) — INT — Foreign key → team.teamseq — NOT NULL
- intuition (직관여부) — BOOLEAN
- hscore (홈팀스코어) — INT
- ascore (원정팀스코어) — INT
member (회원)
- userid (아이디) — VARCHAR — Primary key — NOT NULL
- password (비밀번호) — VARCHAR
- nickname (닉네임) — VARCHAR
- image (프로필 이미지) — VARCHAR
- phone (전화번호) — VARCHAR
- mail (이메일) — VARCHAR
team (팀)
- teamseq (팀 번호) — INT — Primary key — NOT NULL
- teamimg (팀 이미지) — VARCHAR
- team (팀 이름) — VARCHAR
write (일기)
- wseq (일기번호) — INT — Primary key — NOT NULL
- userid (아이디) — VARCHAR — Foreign key → member.userid — NOT NULL
- date (날짜) — DATETIME — Foreign key → game.date — NOT NULL
- teamseq (팀 번호) — INT — Foreign key → game.teamseq — NOT NULL
- title (제목) — VARCHAR
- content (내용) — VARCHAR
- public (공개여부) — BOOLEAN