29 9
Tables (22)
album
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- content — VARCHAR(255)
- visible — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
album_photo
- id — bigint — Primary key — NOT NULL
- album_id — bigint — Foreign key → album.id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
calender
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- summary — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- location — VARCHAR(255)
- start_datetime — VARCHAR(255) — NOT NULL
- end_datetime — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
daily_qna
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- question_id — bigint — Foreign key → question.id — NOT NULL
- answer — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
faq
- id — bigint — Primary key — NOT NULL — 저장된 데이터(연관관계X)
- user_id — bigint — Foreign key → user.id — NOT NULL
- question — VARCHAR(255) — NOT NULL
- answer — VARCHAR(255) — NOT NULL
feedback
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
feedback_photo
- id — bigint — Primary key — NOT NULL
- customer_service_id — bigint — Foreign key → feedback.id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
owner_board
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
owner_board_comment
- id — bigint — Primary key — NOT NULL
- community_id — bigint — Foreign key → owner_board.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
owner_board_photo
- id — bigint — Primary key — NOT NULL
- owner_community_id — bigint — Foreign key → owner_board.id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
pet
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- size — VARCHAR(255) — Enum
- species — VARCHAR(255) — NOT NULL
- gender — VARCHAR(255) — NOT NULL — 암,수,중성화
- birthday — VARCHAR(255) — NOT NULL
- photo — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
pet_growth
- id — bigint — Primary key — NOT NULL
- animal_id — bigint — Foreign key → pet.id — NOT NULL
- weight — VARCHAR(255) — NOT NULL
- month — VARCHAR(255) — NOT NULL
place
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- place_name — VARCHAR(255) — NOT NULL
- place_info — VARCHAR(255) — NOT NULL
- type — VARCHAR(255) — NOT NULL — Enum
- ratio — VARCHAR(255)
- address — VARCHAR(255) — NOT NULL
- latitude — VARCHAR(255) — NOT NULL
- longitude — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
place_photo
- id — bigint — Primary key — NOT NULL
- place_id — bigint — Foreign key → place.id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
place_review
- id — bigint — Primary key — NOT NULL
- place_id — bigint — Foreign key → place.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- content — VARCHAR(255) — NOT NULL
- ratio — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
question
- id — bigint — Primary key — NOT NULL
- question — VARCHAR(255) — NOT NULL
- date — VARCHAR(255) — NOT NULL
response
- id — bigint — Primary key — NOT NULL
- customer_service_id — bigint — Foreign key → feedback.id — NOT NULL
- answer — VARCHAR(255) — NOT NULL
trade_board
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- category — VARCHAR(255) — NOT NULL — Enum
- title — bigint — NOT NULL
- content — VARCHAR(255) — NOT NULL
- price — bigint — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
trade_board_photo
- id — bigint — Primary key — NOT NULL
- trade_community_id — bigint — Foreign key → trade_board.id — NOT NULL
- photo_url — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
user
- id — bigint — Primary key — NOT NULL
- user_info_id — bigint — Foreign key → user_private_info.id — NOT NULL
- nickname — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
user_private_info
- id — bigint — Primary key — NOT NULL
- auth_id — bigint — NOT NULL — 구글 OAuth
- name — VARCHAR(255) — NOT NULL
- mobile_num — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- deleted_at — VARCHAR(255)
user_role
- id — bigint — Primary key — NOT NULL
- id2 — bigint — Foreign key → user.id — NOT NULL
- role — VARCHAR(255) — NOT NULL