aer

Tables (5)

Like (찜)

  • like (찜) — Primary key — NOT NULL
  • user (사용자) — Long — Foreign key → User.user — NOT NULL
  • post (게시글) — Long — Foreign key → Post.post — NOT NULL

Post (게시글)

  • post (게시글) — Long — Primary key — NOT NULL
  • user (사용자) — Long — Foreign key → User.user — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • category (카테고리) — String
  • type (유형) — String
  • date (마감날짜) — Date
  • Field (인원 수) — int
  • link (채팅방 링크) — String
  • created (생성날짜) — Date

Reply (댓글)

  • reply (댓글) — Long — Primary key — NOT NULL
  • post (게시글) — Long — Foreign key → Post.post — NOT NULL
  • user (사용자) — Long — Foreign key → User.user — NOT NULL
  • content (내용) — String
  • created (생성날짜) — Date

Team (팀)

  • Key — Primary key — NOT NULL
  • name (이름) — String
  • Field

User (사용자)

  • user (사용자) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • name (이름) — String
  • major (전공) — String
  • number (학번) — Long
  • age (나이) — Long
  • introduction (자기소개) — Long
  • category (선호 카테고리) — String