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) — 투표 항목취소시 표시하는값