상임위원회 좌석관리 ERD
테이블 (7)
tb_ecss_committee_member (위원회 참석자 명단)
- user_id (key) — character varying(20) — 기본 키 — NOT NULL
- generation_num (Key) — character varying(3) — 기본 키 — NOT NULL
- committee_type_cd (Key2) — character varying(2) — 기본 키 — NOT NULL
- committee_id (Key3) — character varying(3) — 기본 키 — NOT NULL
- committee_duty_cd (Field) — character varying(20)
- seat_no (Field2) — character varying(4)
- term_st_dt (Field3) — character varying(8)
- term_ed_dt (Field4) — character varying(8)
- note (Field5) — character varying(100)
- reg_dt (Field6) — timestamp with time zone
- up_dt (Field7) — timestamp with time zone
- reg_id (Field8) — character varying(20)
- up_id (Field9) — character varying(20)
- com_ip (Field10) — character varying(3)
- room_no (Key4) — numeric — 외래 키 → tb_ecss_room_ip_mapping.room_no — NOT NULL
- seat_no (Key22) — numeric — 외래 키 → tb_ecss_room_ip_mapping.seat_no — NOT NULL
tb_ecss_ip_mapping (본회의장 좌석표)
- s_no (Key) — numeric — 기본 키 — NOT NULL
- ip (Field) — numeric
tb_ecss_room_ip_mapping (위원회 좌석표)
- room_no (Key) — numeric — 기본 키 — NOT NULL
- seat_no (Key2) — numeric — 기본 키 — NOT NULL
- ip (Field) — numeric
- room_no (key) — numeric — 외래 키 → tb_ecss_room_seat_config.room_no — NOT NULL
tb_ecss_room_seat_config (위원회 좌석설정)
- room_no (key) — numeric — 기본 키 — NOT NULL
- horz_cnt (Field) — smalint
- vert_cnt (Field2) — smallint
- ip_prefix (Field3) — character varying(12)
- reg_date (Field4) — timestamp with time zone
- room_no (key2) — numeric — 외래 키 → tb_ecss_room_set.room_no — NOT NULL
tb_ecss_room_set (위원회 회의실 관리)
- room_no (key) — numeric — 기본 키 — NOT NULL
- committee_type_cd (Field) — character varying(2)
- committee_id (Field2) — character varying(3)
- reg_dt (Field3) — timestamp with time zone
- up_dt (Field4) — timestamp with time zone
- room_nm (Field5) — character varying(20)
- st_ip (Field6) — character varying(15)
- ed_ip (Field7) — character varying(15)
- use_yn (Field8) — character varying(1)
tb_ecss_seat (본회의장 좌석사용자)
- user_id (key) — character varying(20) — 기본 키 — NOT NULL
- seat_no (Field) — character varying(3)
- seat_ip (Field2) — character varying(20)
tb_ecss_seat_config (좌석설정)
- cfg_seq (key) — numeric — 기본 키 — NOT NULL
- horz_cnt (Field) — smalint
- vert_cnt (Field2) — smallint
- ip_prefix (Field3) — character varying(12)
- reg_date (Field4) — timestamp with time zone