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