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