management

Tables (24)

Approval

  • ApprovalID — INT
  • EmployeeID — INT — NOT NULL
  • ApproverID — INT — NOT NULL
  • Status — ENUM('Pending', 'Approved', 'Rejected')
  • DocumentPath — VARCHAR(255)
  • CreatedAt — TIMESTAMP
  • UpdatedAt — TIMESTAMP

Attendance

  • AttendanceID — INT
  • EmployeeID — INT — NOT NULL
  • CheckInTime — TIMESTAMP
  • CheckOutTime — TIMESTAMP
  • WorkHours — FLOAT
  • WorkDate — DATE — NOT NULL

BOARD

  • BOARD_ID — CHAR(64) — Primary key — NOT NULL — 게시판별 번호를 부여하여 특정성 부여
  • USER_HASH_ID — CHAR(64) — NOT NULL — SHA-256기반 해시값
  • STATE — ENUM('공개', '비공개', '삭제됨') — NOT NULL
  • TITLE — VARCHAR(50) — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • LIKE_COUNT — INT — NOT NULL
  • COMMENT — 'SHA-256기반 — SHA-256기반 해시값
  • _COUNT — INT — NOT NULL
  • CREATE_AT — TIMESTAMP — NOT NULL

BOARD_MAPPING

  • BOARD_ID — CHAR(64) — Primary key — NOT NULL
  • FILE_ID — CHAR(64) — Primary key — NOT NULL

CHALLENGER_LIST

  • Match_Code — CHAR(64) — Primary key — NOT NULL
  • TEAM_ID — CHAR(64) — Primary key — NOT NULL

CHATTING

  • CHAT_ID — CHAR(64) — Primary key — NOT NULL
  • STATE — VARCHAR(10) — 비공개 공개
  • TITLE — VARCHAR(50) — NOT NULL
  • CREATE_AT — TIMESTAMP — NOT NULL

CHATTING_MAPPING

  • MESSAGE_ID — CHAR(64) — Primary key — NOT NULL
  • FILE_ID — CHAR(64) — Primary key — NOT NULL

CHATTING_MEMBER

  • USER_HASH_ID — CHAR(64) — Primary key — NOT NULL
  • CHAT_ID — CHAR(64) — Primary key — NOT NULL

CHATTING_MESSAGE

  • MESSAGE_ID — CHAR(64) — Primary key — NOT NULL
  • CHAT_ID — CHAR(64) — NOT NULL
  • USER_HASH_ID — CHAR(64) — NOT NULL — SHA-256기반 해시값
  • MESSAGE — TEXT
  • READ — BOOLEAN — NOT NULL
  • CREATE_AT — TIMESTAMP

COMMENT

  • COMMENT_ID — CHAR(64) — NOT NULL — BOARD_ID` CHAR(64) NOT NUL
  • USER_HASH_ID — CHAR(64) — NOT NULL
  • STATE — ENUM('공개중', '비공개', '삭제됨') — NOT NULL
  • CONTENT — TEXT — NOT NULL
  • LIKE_COUNT — INT
  • CHANGE_AT — TIMESTAMP
  • CREATE_AT — TIMESTAMP — NOT NULL

Calendar

  • EventID — INT
  • EmployeeID — INT — NOT NULL
  • Title — VARCHAR(100) — NOT NULL
  • Description — TEXT
  • StartDate — DATETIME — NOT NULL
  • EndDate — DATETIME — NOT NULL
  • CreatedAt — TIMESTAMP

Department

  • DepartmentID — INT
  • DepartmentName — VARCHAR(50) — NOT NULL
  • ManagerID — INT

Email

  • EmailID — INT
  • SenderID — INT — NOT NULL
  • ReceiverEmail — VARCHAR(100) — NOT NULL
  • Subject — VARCHAR(200) — NOT NULL
  • Body — TEXT — NOT NULL
  • AttachmentPath — VARCHAR(255)
  • SentAt — TIMESTAMP

Employee

  • EmployeeID — INT
  • Name — VARCHAR(50) — NOT NULL
  • Email — VARCHAR(100) — NOT NULL
  • PasswordHash — VARCHAR(255) — NOT NULL
  • Phone — VARCHAR(20)
  • DepartmentID — INT
  • RoleID — INT
  • JoinDate — DATE — NOT NULL
  • IsActive — BOOLEAN
  • CreatedAt — TIMESTAMP
  • UpdatedAt — TIMESTAMP

FILE

  • FILE_ID — CHAR(64) — Primary key — NOT NULL
  • USER_HASH_ID — CHAR(64) — NOT NULL — SHA-256기반 해시값
  • NAME — VARCHAR(50) — NOT NULL
  • CREATE_AT — TIMESTAMP — NOT NULL
  • FILE_PATH — VARCHAR(100) — NOT NULL

MATCHCREATE

  • Match_Code — CHAR(64) — Primary key — NOT NULL
  • Stadium_code — CHAR(64)
  • TEAM_ID — CHAR(64) — NOT NULL
  • Challenger — CHAR(64)
  • winner_id — CHAR(64) — 경기 종료 후 입력
  • loser_id — CHAR(64) — 경기 종료 후 입력
  • State — ENUM('경기잡힘', '경기취소', '대기중', '경기종료') — 경기 상태
  • Match_date — DATETIME — NOT NULL
  • Match_type — ENUM('축구', '야구', '농구', '풋살', '배드민턴') — NOT NULL — 종목
  • loan — BOOLEAN — NOT NULL
  • Winner_score — INT — 경기 종료 후 입력
  • Loser_score — INT — 경기 종료 후 입력
  • etc — VARCHAR(255)

NOTIFICATION

  • ALARM_ID — CHAR(64) — Primary key — NOT NULL
  • SENDER — CHAR(64) — NOT NULL
  • RECEIVER — CHAR(64) — NOT NULL
  • CONTENT — TEXT
  • STATE — TINYINT

NoticeBoard

  • NoticeID — INT
  • Title — VARCHAR(100) — NOT NULL
  • Content — TEXT — NOT NULL
  • AuthorID — INT — NOT NULL
  • CreatedAt — TIMESTAMP
  • UpdatedAt — TIMESTAMP

Role

  • RoleID — INT
  • RoleName — VARCHAR(50) — NOT NULL
  • PermissionLevel — INT — NOT NULL

STADIUM

  • Stadium_code — CHAR(64) — Primary key — NOT NULL
  • Stadium_name — VARCHAR(30) — NOT NULL
  • Stadium_region — VARCHAR(30) — NOT NULL
  • Stadium_many — INT
  • availableDays — VARCHAR(30) — NOT NULL
  • availableHours — VARCHAR(30) — NOT NULL
  • Stadium_tel — VARCHAR(30)
  • Stadium_cost — INTEGER

STADIUM_MAPPING

  • Stadium_code — CHAR(64) — Primary key — NOT NULL
  • FILE_ID — CHAR(64) — Primary key — NOT NULL

TEAM

  • TEAM_ID — CHAR(64) — Primary key — NOT NULL
  • TEAM_TYPE — ENUM('개인', '팀') — 개인 or 팀
  • TEAM_IMG — VARCHAR(255)
  • TEAM_NAME — VARCHAR(20) — NOT NULL
  • REGION — VARCHAR(30) — NOT NULL
  • AVG_AGE — VARCHAR(10) — NOT NULL — 10대, 20대, 30대
  • RATING — VARCHAR(5) — NOT NULL — 레이팅 점수
  • TEAM_CASE — VARCHAR(20) — 청소년, 대학생, 직장인, 일반 동호회, 여성, 기타
  • TOTAL_MEMBER — INT — NOT NULL — 팀에 속한 총 인원
  • INTRODUCTION — TEXT
  • TOTAL_REVIEW — INT — NOT NULL
  • EVENT — ENUM('축구', '야구', '농구', '풋살', '배드민턴') — NOT NULL — 종목
  • Match_Count — INT — NOT NULL — Default = 0
  • WinCount — INT — NOT NULL — Default = 0
  • LoseCount — INT — NOT NULL — Default = 0
  • DrawCount — INT — NOT NULL — Default = 0

TEAM_MAPPING

  • USER_HASH_ID — VARCHAR(64) — Primary key — NOT NULL — SHA-256기반 해시값
  • TEAM_ID — VARCHAR(30) — Primary key — NOT NULL
  • POSITION — VARCHAR(20)

USERS

  • USER_HASH_ID — CHAR(64) — Primary key — NOT NULL — 로그인에 사용
  • STATE — ENUM('활성화', '삭제대기') — NOT NULL
  • Division — ENUM('유저', '관리자', '사업자') — NOT NULL
  • NAME — VARCHAR(20) — NOT NULL
  • E_MAIL — VARCHAR(80) — NOT NULL — 본인인증
  • PASSWORD — VARCHAR(30) — NOT NULL
  • TEL — VARCHAR(15) — NOT NULL — 축구/농구/배드민턴
  • PREFER_SPORTS — VARCHAR(30) — 성별
  • REGION — VARCHAR(30) — NOT NULL
  • Badminton_Score — VARCHAR(5)
  • Tennis_Score — VARCHAR(5)
  • Table_Tennis_Score — VARCHAR(5)
  • Bowling_Score — VARCHAR(5)
  • GENDER — ENUM('남자', '여자') — NOT NULL — 게시판번호 + COMMENT001
  • BIRTH — TIMESTAMP
  • PROFILE — VARCHAR(255)
  • CREATED_AT — TIMESTAMP — NOT NULL