millinare

Tables (8)

GroupJoinRequest (그룹 가입 요청)

  • id — LONG — Primary key — NOT NULL
  • 유저id (user_id) — LONG — Foreign key → User.id — NOT NULL
  • 그룹Id (group_id) — LONG — Foreign key → group.id — NOT NULL
  • 생성일시 (create_time) — LOCALDATE
  • 수정일시 (update_time) — LOCALDATE
  • 삭제여부 (is_deleted) — BOOLEAN

User (사용자)

  • id — LONG — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(30)
  • 이메일 (email) — VARCHAR(150)
  • 생성일시 (createdAt) — LOCALDATE
  • 수정일시 (updatedAt) — LOCALDATE
  • 삭제여부 (IsDeleted) — BOOLEAN

appeal (이의제기)

  • id — LONG — Primary key — NOT NULL
  • 태스크id (task_id) — LONG — Foreign key → task.Id — NOT NULL
  • content — VARCHAR(300)
  • 상태 (status) — VARCHAR(20)
  • 생성일시 (created_at) — LOCALDATE
  • 수정일시 (updated_at) — LOCALDATE
  • 삭제여부 (Is_deleted) — BOOLEAN

auth (인증)

  • id — LONG — Primary key — NOT NULL
  • 태스크Id (task_id) — LONG — Foreign key → task.Id — NOT NULL
  • content — text
  • 생성일시 (created_at) — LOCALDATE
  • 수정일시 (updated_at) — LOCALDATE
  • 삭제여부 (Id_deleted) — BOOLEAN

auth_image (인증 이미지)

  • id — LONG — Primary key — NOT NULL
  • auth_id (id2) — LONG — Foreign key → auth.id — NOT NULL
  • image — image
  • 생성일시 (created_at) — LOCALDATE
  • 삭제여부 (updated_at) — LOCALDATE
  • 삭제여부 (Is_deleted) — BOOLEAN

group (그룹)

  • id — LONG — Primary key — NOT NULL
  • 그룹 이름 (group_name) — VARCHAR(200)
  • 그룹 프로필 이미지 (group_image) — image
  • 생성일시 (created_at) — LOCALDATE
  • 수정일시 (updated_at) — LOCALDATE
  • 삭제여부 (Id_deleted) — BOOLEAN
  • 공지 (notice) — VARCHAR(500)
  • 월 벌금 (monthly_penalty) — BIGINT
  • 주 벌금 (weekly_penalty) — BIGINT
  • 일 벌금 (daily_penalty) — BIGINT
  • Field — BOOL

groupmember (그룹 멤버)

  • id — LONG — Primary key — NOT NULL
  • 유저 Id (user_id) — LONG — Foreign key → User.id — NOT NULL
  • 그룹 id (group_id) — LONG — Foreign key → group.id — NOT NULL
  • 권한 (role) — VARCHAR(100)
  • 벌금 (penalty) — LONG
  • 생성일시 (create_at) — LOCALDATE
  • 수정일시 (updated_at) — LOCATDATE
  • 삭제여부 (Is_deleted) — BOOLEAN

task (목표)

  • Id (id) — LONG — Primary key — NOT NULL
  • 그룹멤버id (groupmember_id) — LONG — Foreign key → groupmember.id — NOT NULL
  • type — VARCHAR(50)
  • content — text
  • status — VARCHAR(20)
  • 날짜 (due_date) — LOCALDATE
  • 생성일시 (created_at) — LOCALDATE
  • 수정일시 (updated_at) — LOCALDATE
  • 삭제여부 (is_deleted) — BOOLEAN