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