uspray_migration
Tables (7)
category (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (유저아이디) — bigint — Foreign key → Member.id — NOT NULL
- name (이름) — string
- color (색상) — string
- order (순서) — int
History (히스토리)
- id (아이디) — bigint — Primary key — NOT NULL
- member_id (유저아이디) — bigint — Foreign key → Member.id — NOT NULL
- content (내용) — varchar
- count (횟수) — int
- deadline (마감일) — datetime
- created_at (기도생성일자) — datetime
Member (유저)
- id (아이디) — bigint — Primary key — NOT NULL
- password (비밀번호) — varchar
- phone (전화번호) — varchar
- birth (생일) — datetime
- gender (성별) — varchar
- name (이름) — varchar
- userId (유저아이디) — varchar
- created_at (가입일자) — datetime
- updated_at (수정일자) — datetime
- is_deleted (탈퇴여부) — boolean
- deleted_reason (탈퇴이유) — bigint
Notification (알림)
- id (아이디) — bigint — Primary key — NOT NULL
- content (내용) — varchar
Pray (기도제목)
- id (아이디) — bigint — Primary key — NOT NULL
- member_id (유저아이디) — bigint — Foreign key → Member.id — NOT NULL
- category_id (카테고리아이디) — bigint — Foreign key → category.id — NOT NULL
- content (내용) — varchar
- count (횟수) — int
- deadline (마감일) — datetime
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
- is_deleted (삭제여부) — boolean
- prayed_at (기도일자) — datetime
- origin_pray_id (기도제목원본) — bigint
- is_shared (공유여부) — boolean
User_notification (유저알림)
- user_id (유저아이디) — bigint — Foreign key → Member.id — NOT NULL
- notification_id (알림아이디) — bigint — Foreign key → Notification.id — NOT NULL
- created_at (생성일자) — datetime
- is_enabled (알람여부) — boolean
shared_pray (보관함)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (유저아이디) — bigint — Foreign key → Member.id — NOT NULL
- pray_id (기도제목아이디) — bigint — Foreign key → Pray.id — NOT NULL
- id (Key2) — bigint — Foreign key → Pray.category_id — NOT NULL
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
- Field