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