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