브라보농어촌라이프
테이블 (9)
p_ai_diary
- id — CHAR(36)
- diaryID — CHAR(36) — NOT NULL
- title — VARCHAR(100)
- content — VARCHAR(255)
p_board
- id — CHAR(36)
- userId — BIGINT — NOT NULL
- title — VARCHAR(100)
- content — VARCHAR(255)
- image — VARCHAR(100)
- category — ENUM('자유질문', '이달의글', '질문하기')
- views — BIGINT
p_board_review
- id — CHAR(36)
- boardId — CHAR(36) — NOT NULL
- userId — BIGINT — NOT NULL
- content — VARCHAR(255)
p_diary
- id — CHAR(36)
- userId — BIGINT — NOT NULL
- title — VARCHAR(100)
- content — VARCHAR(255)
p_exp_review
- id — CHAR(36)
- experienceId — CHAR(36) — NOT NULL
- title — VARCHAR(100)
- content — VARCHAR(255)
- image — VARCHAR(100)
p_experience
- id — CHAR(36)
- hostId — CHAR(36) — NOT NULL
- userId — BIGINT — NOT NULL
- image — VARCHAR(100)
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- career — INT
- meal — VARCHAR(255)
- price — INT — NOT NULL
- notice — VARCHAR(255)
p_host
- id — CHAR(36)
- userId — BIGINT — NOT NULL
- experienceId — CHAR(36) — NOT NULL
- hostType — ENUM('FARM', 'FISHERY') — NOT NULL
- address — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- is_deleted — BOOLEAN
p_reservation
- id — CHAR(36)
- experienceId — CHAR(36) — NOT NULL
- userId — BIGINT — NOT NULL
- experienceDate — DATE — NOT NULL
- status — ENUM('예약접수', '예약확정') — NOT NULL
- participants — INT — NOT NULL
- mealIncluded — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN
p_user
- id — BIGINT
- email — VARCHAR(100) — NOT NULL
- profileImage — VARCHAR(100)
- password — VARCHAR(100) — NOT NULL
- nickName — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — ENUM('MASTER', 'OWNER', 'GUEST', 'INFLUENCER') — NOT NULL