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