B109

Tables (7)

comment

  • comment_idx — bigint — Primary key — NOT NULL
  • content — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • notice_idx — bigint — Foreign key → inquiry.inquiry_idx — NOT NULL

event

  • event_idx — bigint — Primary key — NOT NULL
  • event_title — varchar(256) — NOT NULL
  • event_content — varchar(256)
  • event_startdate — datetime — NOT NULL
  • event_enddate — datetime
  • event_address — varchar(256)
  • event_url — varchar(256)
  • event_created_at — datetime — NOT NULL
  • event_updated_at — datetime
  • member_idx — bigint — Foreign key → member.member_idx — NOT NULL

inquiry

  • inquiry_idx — bigint — Primary key — NOT NULL
  • inquiry_title — varchar(255) — NOT NULL
  • inquiry_content — varchar(255) — NOT NULL
  • inquiry_type — varchar(128)
  • inquiry_created_at — datetime — NOT NULL
  • inquiry_updated_at — datetime
  • member_idx — bigint — Foreign key → member.member_idx — NOT NULL

member

  • member_idx — bigint — Primary key — NOT NULL
  • member_role — varchar(128) — NOT NULL — WEB: 웹 멤버, APP: 앱 멤버
  • member_nickname — varchar(128)
  • member_img_url — varchar(256)
  • member_firebase_token — varchar(256)
  • member_refresh_token — varchar(256)
  • member_social_type — varchar(256) — KAKAO: 카카오, NAVER: 네이버, GOOGLE: 구글
  • member_organization_name — varchar(256)
  • member_status — varchar(256) — WATING,: 승인대기, DECLINED,: 거절, ACCEPTED: 승인
  • member_auth_file — varchar(256)
  • member_auth_img — varchar(256)

notice

  • notice_idx — bigint — Primary key — NOT NULL
  • notice_title — varchar(256) — NOT NULL
  • notice_content — varchar(256) — NOT NULL
  • notice_type — varchar(256) — NOT NULL
  • notice_from — varchar(256) — NOT NULL
  • notice_created_at — datetime — NOT NULL
  • notice_updated_at — datetime

user_map_area

  • user_map_area_idx — bigint — Primary key — NOT NULL
  • region — varchar(128) — NOT NULL
  • dimension — double — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • member_idx — bigint — Foreign key → member.member_idx — NOT NULL

user_marker

  • user_marker_idx — bigint — Primary key — NOT NULL
  • latitude — double — NOT NULL
  • longitude — double — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • member_idx — bigint — Foreign key → member.member_idx — NOT NULL