Prayer&Petition
테이블 (9)
User (user)
- user_id — Integer — 기본 키 — NOT NULL
- email — String — NOT NULL
- password — String — NOT NULL
- phone_number (Field4)
- nickname (Field5)
- profile_image_url (Field6)
- role_id (Field7)
- location_id (Field8)
- created_at (Field9)
권한 (role)
- role_id (Field)
- role_name (Field2)
- description (Field3)
그룹 (group)
- group_id (Field)
- group_name (Field2)
- description (Field3)
- creator_id (Field4)
- created_at (Field5)
그룹멤버 (group_membership)
- membership_id (Field)
- user_id (Field2)
- group_id (Field3)
- role (Field4)
- joined_at (Field5)
기도제목 (prater_request)
- request_id (Field)
- user_id (Field2)
- group_id (Field3)
- title (Field4)
- content (Field5)
- visibility (Field6)
- location_id (Field7)
- is_completed (Field8)
- created_at (Field9)
- updated_at (Field10)
기도참여기록 (prater_log)
- log_id (Field)
- user_id (Field2)
- request_id (Field3)
- prayed_at (Field4)
연락처 (contact)
- contact_id (Field)
- owner_user_id (Field2)
- phone_number (Field3)
- created_at (Field4)
지역 (location)
- location_id (Field)
- location_name (Field2)
- location_type (Field3)
- parent_location_id (Field4)
친구관계 (friendship)
- friendship_id (Field)
- user1_id (Field2)
- user2_id (Field3)
- status (Field4)
- created_at (Field5)