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