ㅇㅇ

Tables (7)

Department

  • departmentId — BIGINT — Primary key — NOT NULL
  • departmentName — VARCHAR(255)
  • manager_id — BIGINT — Foreign key → User.id — NOT NULL

Position

  • positionId — BIGINT — Primary key — NOT NULL
  • positionName — VARCHAR(255)
  • positionRole — VARCHAR(255)

Post

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • createdDate — TIMESTAMP
  • modifiedDate — TIMESTAMP
  • author_id — BIGINT — Foreign key → User.id — NOT NULL
  • modifier_id — BIGINT — Foreign key → User.id — NOT NULL
  • projectId — BIGINT — Foreign key → Project.projectId — NOT NULL

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 — Foreign key → Department.departmentId — NOT NULL
  • position_id — BIGINT — Foreign key → Position.positionId — NOT NULL

Weather

  • weather_id — BIGINT — Primary key — NOT NULL
  • 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

  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • project_id — BIGINT — Foreign key → Project.projectId — NOT NULL