dailyflow
Tables (7)
Department
- departmentId — BIGINT
- departmentName — VARCHAR(255)
- manager_id — BIGINT
Position
- positionId — BIGINT
- positionName — VARCHAR(255)
- positionRole — VARCHAR(255)
Post
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
- author_id — BIGINT
- modifier_id — BIGINT
- project_id — BIGINT
Project
- projectId — BIGINT — Primary key — NOT NULL
- projectName — VARCHAR(255)
- projectDescription — TEXT
User
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(255) — NOT NULL
- employee_number — VARCHAR(255)
- email — VARCHAR(255)
- phone_number — VARCHAR(255)
- hire_date — VARCHAR(255)
- department_id — BIGINT
- position_id — BIGINT
Weather
- weather_id — BIGINT
- baseDate — VARCHAR(255)
- baseTime — VARCHAR(255)
- category — VARCHAR(255)
- fcstDate — VARCHAR(255)
- fcstTime — VARCHAR(255)
- fcstValue — VARCHAR(255)
- nx — VARCHAR(255)
- ny — VARCHAR(255)
project_employee
- project_id — BIGINT
- user_id — BIGINT