1

Tables (5)

Chat (채팅)

  • id — int — Foreign key → User.id — NOT NULL

Group (CopyOf모집)

  • id — Primary key — NOT NULL
  • location (장소) — ?
  • title (제목) — VARCHAR(1000)
  • content (내용) — VARCHAR
  • close_at (마감 시간) — TIMESTAMP'
  • is_closed (마감 여부) — BOOLEAN

Pet (반려동물)

  • id — int — Primary key — NOT NULL
  • naem (이름) — VARCHAR
  • profile (사진) — FILE
  • age (나이) — int
  • personality (성격) — ENU<
  • rating (평점) — int
  • user_id (유저 아이디) — int — Foreign key → User.id — NOT NULL

Recruitment (모집)

  • id — Primary key — NOT NULL
  • user_id (유저 아이디) — int — Foreign key → User.id — NOT NULL
  • group_id (그룹 아이디) — int — Foreign key → Group.id — NOT NULL
  • role (역할) — ENUM
  • status (참여 상태) — ENUM
  • Field

User (인간)

  • id — int — Primary key — NOT NULL
  • created_at (생성일자) — TIMESTAMP
  • updated_at (수정일자) — TIMESTAMP
  • name (이름) — VARCHAR(50)
  • login_id (로그인 아이디) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(200)
  • address (주소) — ?
  • rating (평점) — int
  • personality (성격) — ENUM