meet

Tables (3)

TB_MEETING

  • meeting_id (회의실 장소 번호) — PK(int) — Primary key — NOT NULL
  • name (회의실장소 이름) — varchar(50)
  • created_at (생성날짜) — stamptime
  • updated_at (수정날짜) — stamptime
  • deleted_at (삭제날짜) — stamptime

TB_MEETING_REV (TB_MEET_REV)

  • rev_id (회의실 예약 번호) — PK(int) — Primary key — NOT NULL — ㅌ
  • title (제목) — varchar(100) — NOT NULL
  • start_time (시작시간) — stamptime
  • end_time (종료시간) — stamptime
  • attend_name (참석자이름) — varchar(200)
  • created_at (생성날짜) — stamptime
  • updated_at (수정날짜) — stamptime
  • deleted_at (삭제날짜) — stamptime
  • meeting_id (회의실일련번호) — int(FK) — Foreign key → TB_MEETING.meeting_id — NOT NULL
  • user_id (사용자 번호) — int(FK) — Foreign key → TB_MEETING_USER.user_id — NOT NULL

TB_MEETING_USER

  • user_id (사용자 번호) — PK(int) — Primary key — NOT NULL
  • user_name (사용자 이름) — varchar(50)
  • user_rank (직급) — varchar(50)
  • employee_num (사번) — int
  • created_at (생성날짜) — stamptime
  • updated_at (수정날짜) — stamptime
  • deleted_at (삭제날짜) — stamptime