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