mini

Tables (5)

board

  • board_id — bigint — Primary key — NOT NULL
  • create_date — timestamp — NOT NULL
  • title — text — NOT NULL
  • content — text — NOT NULL
  • member_id — text — Foreign key → members.member_id — NOT NULL

comment

  • comment_id — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • board_id — bigint — Foreign key → board.board_id — NOT NULL
  • member_id — text — Foreign key → members.member_id — NOT NULL
  • create_time — timestamp — NOT NULL

members

  • member_id — text — Primary key — NOT NULL
  • create_date — timestamp — NOT NULL
  • password — text
  • role — text — NOT NULL
  • nickname — text — NOT NULL
  • provider — text — NOT NULL
  • username — text — NOT NULL
  • enabled — boolean — NOT NULL

reviews

  • review_id — bigint — Primary key — NOT NULL
  • create_date — date — NOT NULL
  • content — text — NOT NULL
  • data_cd — text — Foreign key → toilet_info.data_cd — NOT NULL
  • member_id — text — Foreign key → members.member_id — NOT NULL
  • point — bigint — NOT NULL

toilet_info

  • data_cd — text — Primary key — NOT NULL
  • reg_dt — timestamp
  • la_crdnt — double
  • lo_crdnt — double
  • se_nm — text
  • emd_nm — text
  • rn_adres — text
  • lnm_adres — text
  • photo_yn — text
  • etc_cn — text
  • toilet_nm — text
  • opn_time_info — text
  • mngr_instt_nm — text
  • telno — text
  • toilet_posesn_se_nm — text
  • toilet_instl_place_pttn_nm — text
  • filth_prcs_mthd_nm — text
  • emgnc_bell_instl_yn — text
  • toilet_entrnc_cctv_instl_yn — text
  • diaper_exhg_tabl_yn — text
  • mwmn_cmnuse_toilet_yn — text
  • male_closet_cnt — bigint
  • male_urinal_cnt — bigint
  • male_dspsn_closet_cnt — bigint
  • male_dspsn_urinal_cnt — bigint
  • male_child_closet_cnt — bigint
  • male_child_urinal_cnt — bigint
  • female_closet_cnt — bigint
  • female_dspsn_closet_cnt — bigint
  • female_child_closet_cnt — bigint
  • photo — text