상임위원회 좌석관리 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