nuneol

Tables (3)

prayer (기도)

  • id (기도ID) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(100)
  • content (내용) — text
  • category (카테고리) — enum
  • prayed_count (기도카운트) — int
  • created_at (생성일)
  • id (유저ID) — bigint — Foreign key → user.id — NOT NULL

report (신고)

  • id (신고ID) — bigint — Primary key — NOT NULL
  • reason (사유) — varchar(100)
  • created_at (신고일시) — datetime
  • id (기도ID) — bigint — Foreign key → prayer.id — NOT NULL

user (유저)

  • id (유저ID) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • nickname (닉네임) — varchar
  • password (비밀번호) — varchar
  • created_at (가입일) — datetime