5th_Practice

Tables (7)

addPayment (Untitled6)

  • id (Key) — INT — Primary key — NOT NULL
  • content (Field) — VARCHAR(2000)
  • contractURL (Field2) — VARCHAR(1000)
  • payment (Field3) — INT
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE
  • ProejctId (Key2) — INT — Foreign key → projects.id — NOT NULL

client (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • Field

employee (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • Field

participates (Untitled7)

  • id (Key) — INT — Primary key — NOT NULL
  • ProjectId (Key2) — INT — Foreign key → projects.id — NOT NULL
  • EmpId (Key3) — INT — Foreign key → employee.id — NOT NULL

projects (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • stateDate (Field2) — DATE
  • endDate (Field3) — DATE
  • content (Field5) — VARCHAR(2000)
  • payment (Field4) — INT
  • advance (Field6) — INT
  • contractURL (Field7) — VARCHAR(1000)
  • ManagerId (Key2) — INT — Foreign key → employee.id — NOT NULL
  • TeamId (Key3) — INT — Foreign key → team.id — NOT NULL
  • ClientId (Key4) — INT — Foreign key → client.id — NOT NULL
  • createdAt (Field8) — DATE
  • updatedAt (Field9) — DATE
  • refURL1 (Field10) — VARCHAR(300)
  • refURL2 (Field11) — VARCHAR(300)
  • domain (Field12) — VARHCAR(300)
  • envFile (Field13) — VARCHAR(2000)
  • endPassword (Field14) — VARCHAR(500)

team (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • Field

works (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(200)
  • content (Field2) — VARCHAR(2000)
  • memo (Field9) — VARCHAR(500)
  • isCompleted (Field3) — TINYINT(1)
  • completedAt (Field4) — DATE
  • WorkerId (Key2) — INT — Foreign key → employee.id — NOT NULL
  • ProejctId (Key3) — INT — Foreign key → projects.id — NOT NULL
  • filename (Field8) — VARCHAR(100)
  • fileURL (Field7) — VARCHAR(1000)
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE
  • limitDate (Field10) — DATE