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