test

Tables (15)

Agreement (Untitled15)

  • agreementId (Key4) — Primary key — NOT NULL
  • ruleId (Key2) — Foreign key → Rule.ruleId — NOT NULL
  • projectId (Key) — long — Foreign key → Rule.projectId — NOT NULL
  • memberId (Key3) — long — Foreign key → Member.memberId — NOT NULL
  • agree (Field) — boolean
  • deleted (Field2)

Member (Untitled)

  • memberId (Key) — long — Primary key — NOT NULL
  • nickName (Field) — string
  • email (Field2) — string
  • imgUrl (Field3) — string
  • memberType (Field4) — enum
  • password (Field5)
  • deleted (Field6)
  • createDate (Field7)
  • updateDate (Field8)

Project (Untitled2)

  • projectId (Key) — long — Primary key — NOT NULL
  • projectName (Field) — string
  • projectCode (Field2) — string
  • createDate (Field3) — localDateTime
  • deadLine (Field4) — localDateTime
  • startIme (Field5) — localDateTime
  • deleted (Field6)
  • updateDate (Field7)

Rule (Untitled12)

  • ruleId (Key2) — Primary key — NOT NULL
  • projectId (Key) — long — Foreign key → Project.projectId — NOT NULL
  • createDate (Field4)
  • updateDate (Field5)
  • content (Field) — markdown 식으로 저장
  • deleted (Field2)

data (Untitled13)

  • dataId (Key) — Primary key — NOT NULL
  • taskid (Key3) — Foreign key → task.taskid — NOT NULL
  • projectId (Key2) — 표기용값 — Foreign key → task.projectId — NOT NULL
  • memberId (Key22) — 표기용값 — Foreign key → task.memberId — NOT NULL
  • memberId (Key4) — long — Foreign key → Member.memberId — NOT NULL
  • createDate (Field)
  • deleted (Field2)
  • dataType (Field3)
  • content (Field4) — string

notify (Untitled6)

  • notiftId (Key2) — Primary key — NOT NULL
  • projectId (Key) — long — Foreign key → Project.projectId — NOT NULL
  • createDate (Field)
  • content (Field2)
  • deleted (Field3)
  • updateDate (Field4)
  • title (Field5)

proceddinglog (Untitled8)

  • proceddingLogId (Key3) — Primary key — NOT NULL
  • proceedingId (Key2) — long — Foreign key → proceedings.proceedingId — NOT NULL
  • projectId (Key) — 없어도되는값 그냥 표기상 들어간거 — Foreign key → proceedings.projectId — NOT NULL
  • memberId (Key5) — long — Foreign key → Member.memberId — NOT NULL
  • deleted (Field) — boolean

proceedings (Untitled7)

  • proceedingId (Key2) — Primary key — NOT NULL
  • projectId (Key) — long — Foreign key → Project.projectId — NOT NULL
  • titile (Field)
  • createDate (Field2)
  • deleted (Field3)
  • updateDate (Field4)
  • content (Field5)

report (Untitled14)

  • projectId (Key) — long — Foreign key → Project.projectId — NOT NULL
  • memberId (Key2) — long — Foreign key → Member.memberId — NOT NULL

task (Untitled4)

  • taskid (Key3) — Primary key — NOT NULL
  • projectId (Key) — long — Foreign key → Project.projectId — NOT NULL
  • memberId (Key2) — 실제로 관계설정보단 값만 넣어서 탈부착 용이하게 — Foreign key → Member.memberId — NOT NULL
  • deadLine (Field) — localDateTime
  • task (Field2) — string
  • deleted (Field3) — boolean
  • taskState (Field4) — enum

taskPartcipation (Untitled5)

  • memberId (Key4) — 표기값 — Foreign key → Member.memberId — NOT NULL
  • taskid (Key3) — 회원 아이디값과 묶어서 unique 값 — Foreign key → task.taskid — NOT NULL
  • projectId (Key) — 표기값 — Foreign key → task.projectId — NOT NULL
  • memberId (Key2) — 회원값 — Foreign key → task.memberId — NOT NULL
  • deleted (Field) — boolean

ticket (Untitled3)

  • memberId (Key) — 이거랑 projectId 묶어서 unique — Foreign key → Member.memberId — NOT NULL
  • projectId (Key2) — long — Foreign key → Project.projectId — NOT NULL
  • createDate (Field) — localDateTime
  • role (Field2) — string
  • ticketGrad (Field3) — enum
  • deleted (Field4) — boolean

vote (Untitled9)

  • voteId (Key) — Primary key — NOT NULL
  • projectId (Key2) — long — Foreign key → Project.projectId — NOT NULL
  • deadline (Field)
  • createDate (Field2) — localDateTime
  • updateDate (Field3) — localDateTime
  • deleted (Field4)
  • title (Field5)

voteList (Untitled10)

  • voteListId (Key) — Primary key — NOT NULL
  • voteId (Key2) — Foreign key → vote.voteId — NOT NULL
  • projectId (Key22) — 없어도되는값 그냥 표기상 들어간거 — Foreign key → vote.projectId — NOT NULL
  • content (Field)
  • deleted (Field2)

voteParticipation (Untitled11)

  • voteListId (Key2) — 이거랑 memberId묶어서 unique — Foreign key → voteList.voteListId — NOT NULL
  • id (Key22) — 없어도되는값 그냥 표기상 들어간거 — Foreign key → voteList.voteId — NOT NULL
  • projectId (Key222) — 없어도되는값 그냥 표기상 들어간거 — Foreign key → voteList.projectId — NOT NULL
  • memberId (Key3) — long — Foreign key → Member.memberId — NOT NULL
  • deleted (Field) — 투표 항목취소시 표시하는값