Final-project
Tables (35)
ALLIM
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- type — INT
- start_date — DATETIME
- check_date — DATETIME
- check_yn — INT
- start_id — VACHAR(200)
ANNUAL
- id — BIGINT — Primary key — NOT NULL
- count — INT
- type — INT
- reg — DATE
- member_id — BIGINT — NOT NULL
APPROVAL
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → APPROVALCATEGORY.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- contents — LONGTEXT
- date — DATETIME
- confirm — VARCHAR(10)
- fin — DATETIME
APPROVALCATEGORY
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200)
- ref — BIGINT
APPROVALFORMFILE
- category_id — BIGINT — Foreign key → APPROVALCATEGORY.id — NOT NULL
- file_name — varchar(200)
APPROVALHISTORY
- id — BIGINT — Primary key — NOT NULL
- approval_id — BIGINT — Foreign key → APPROVAL.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- approval_date — DATETIME
- check — VARCHAR(10)
APPROVALINFO
- id — BIGINT — Primary key — NOT NULL
- approval_id — BIGINT — Foreign key → APPROVAL.id — NOT NULL
- member_id — BIGINT — Foreign key → APPROVAL.member_id — NOT NULL
- date — DATETIME
- check — VARCHAR(10)
- depth — INT
APPROVALUPLOADFILE
- id — BIGINT — Primary key — NOT NULL
- approval_id — BIGINT — Foreign key → APPROVAL.id — NOT NULL
- name — VARCHAR(200)
APPROVER
- category_id — BIGINT — Foreign key → APPROVALCATEGORY.id — NOT NULL
- job_id — BIGINT — Foreign key → JOB.id — NOT NULL
- department_id — BIGINT — Foreign key → DEPARTMENT.id — NOT NULL
- depth — INT
BOARD
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title — VARCHAR(200)
- contents — LONGTEXT
- writer — VARCHAR(200)
- reg_date — DATE
- hit — BIGINT
BOARDFILES
- id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARD.id — NOT NULL
- file_name — VARCHAR(200)
- ori_name — VARCHAR(200)
CHATGROUP
- chat_id — BIGINT — Foreign key → CHATROOM.id — NOT NULL
- member_id — VARCHAR(200) — Foreign key → MESSAGE.member_id — NOT NULL
CHATROOM
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200)
- status — BIT
DATE
- CALENDAR_ID — BIGINT — Primary key — NOT NULL
- CALENDAR_DATE — BIGINT
- CALENDAR_YEAR — BIGINT
- CALENDAR_MM — BIGINT
- CALENDAR_DD — DATE
- CALENDAR_WEEKOFYEAR — TIMESTAMP
- CALENDAR_WEEKOFMONTH — TIMESTAMP
- CALENDAR_WEEK — BIGINT
- CALENDAR_DAYOFWEEK — BIGINT
DEPARTMENT
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200)
- manager — BIGINT
- upper — BIGINT
- level — INT
- create_date — DATE
- update_date — DATE
DOCUMENT
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200)
- info — LONGTEXT
- writer — BIGINT
DOCUMENTFILES
- id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → DOCUMENT.id — NOT NULL
- file_name — VARCHAR(200)
- ori_name — VARCHAR(200)
EMPLOYEESTATUS
- id — BIGINT — Primary key — NOT NULL
- reg — DATE
- on_time — DATETIME
- off_time — DATETIME
- status — VARCHAR(200)
- member_id — BIGINT — NOT NULL
HOLIDAY
- id — BIGINT — Primary key — NOT NULL
- type — BIGINT
- title — BIGINT
- content — BIGINT
- reg_date — DATE
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- allday — BIGINT
- status — BIGINT
- color — BIGINT
JOB
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200)
LEAVERECODE
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- approval_id — BIGINT — Foreign key → APPROVAL.id — NOT NULL
- reason — LONGTEXT
- type — VARCHAR2(200)
- count — INT
- use_date — DATE
- annual_type — VARCHAR(200)
MEMBER
- id — BIGINT — Primary key — NOT NULL
- employee_id — BIGINT — Primary key — NOT NULL
- account_id — VARCHAR(200) — Primary key — NOT NULL
- job_id — BIGINT — Foreign key → JOB.id — NOT NULL
- password — VARCHAR(200)
- name — VARCHAR(200)
- birth_date — DATE
- email — VARCHAR(200)
- phone — VARCHAR(200)
- address — VARCHAR(200)
- reg_date — DATE
- update_date — DATE
- hire_date — DATE
- end_date — DATE
- status — BIT
- department_id — BIGINT — NOT NULL
MEMBERROLE
- role_id — BIGINT — Foreign key → ROLE.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
MESSAGE
- id — BIGINT — Primary key — NOT NULL
- chat_id — BIGINT — Foreign key → CHATROOM.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- content — VARCAHR(200)
- time — DATETIME
- status — BIT
NOTICE
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title — VARCHAR(200)
- contents — LONGTEXT
- writer — VARCHAR(200)
- reg_date — DATE
- hit — BIGINT
- important — TINYINT(1)
NOTICEFILES
- id — BIGINT — Primary key — NOT NULL
- notice_id — BIGINT — Foreign key → NOTICE.id — NOT NULL
- file_name — VARCHAR(200)
- ori_name — VARCHAR(200)
PROFILE
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- file_name — VARCHAR(200)
- ori_name — VARCHAR(200)
QNA
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title — VARCHAR(200)
- contents — LONGTEXT
- writer — VARCHAR(200)
- reg_date — DATE
- hit — BIGINT
QNACOMMENT
- id — BIGINT — Primary key — NOT NULL
- qna_id — BIGINT — Foreign key → QNA.id — NOT NULL
- contents — LONGTEXT
- writer — VARCHAR(200)
- reg_date — DATE
- ref — BIGINT
- step — BIGINT
- depth — BIGINT
QNAFILES
- id — BIGINT — Primary key — NOT NULL
- qna_id — BIGINT — Foreign key → QNA.id — NOT NULL
- file_name — VARCHAR(200)
- ori_name — VARCHAR(200)
ROLE
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200)
SCHEDULE
- id — INT(10) — Primary key — NOT NULL
- title — VARCHAR(50)
- type — BIGINT
- start_date — DATE
- start_hour — DATE
- start_minute — TINYINT
- end_date — TINYINT
- end_hour — TINYINT
- end_minute — TINYINT
- repeat_type — CHAR(1)
- repeat_option — VARCHAR(2)
- repeat_end — VARCHAR(10)
- content — TEXT
- isopen — TINYINT(1)
- updatedate — DATETIME
- insertdate — DATETIME
- usernum — INT(10)
- deleteflag — TINYINT(1)
SCHEDULE_DETAIL
- id — TINYINT(1) — Primary key — NOT NULL
- seq — SMALLINT
- date — DATE
- hour — TINYINT
- minute — TINYINT
USERADDRESS
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- add_id — VARCHAR(200)
WORKTIME
- id — BIGINT — Primary key — NOT NULL
- start_time — TIME
- finish_time — TIME
- meal_time — bit
- reg_date — DATE
- member_id — BIGINT — NOT NULL