Damoyeo

Tables (12)

Damoyeo_Applications (모임 신청자 테이블)

  • application_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 키
  • meetup_id — int — Foreign key → Damoyeo_Meetup.meetup_id — NOT NULL — Key
  • application_date — datetime — NOT NULL — 신청일자

Damoyeo_Category (카테고리명)

  • category_id — int — Primary key — NOT NULL — key
  • category_name — VARCHAR(50) — NOT NULL — 카테고리명

Damoyeo_Community (커뮤니티테이블)

  • board_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 키
  • title — varchar(100) — NOT NULL — 텍스트
  • content — text — NOT NULL — 내용
  • use_tf — char(1) — NOT NULL — 게시일
  • post_date — datetime — NOT NULL — 등록일
  • view_count — int — NOT NULL — 조회수

Damoyeo_Community_Comment (댓글테이블)

  • comment_id — int — Primary key — NOT NULL
  • parent_commentid — int — NOT NULL — 부모 댓글id
  • board_id — int — Foreign key → Damoyeo_Community.board_id — NOT NULL
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 키
  • content — varchar(MAX) — NOT NULL — 댓글내용
  • comment_date — datetime — NOT NULL — 댓글등록일
  • use_tf — char(1) — NOT NULL — 사용여부

Damoyeo_Image (이미지테이블)

  • Id — int — Primary key — NOT NULL
  • save_filename — varchar(300) — NOT NULL — 저장파일명
  • origin_filename (Field) — varchar(300) — NOT NULL — 원본파일명
  • table_name (Field2) — varchar(50) — NOT NULL — 테이블명
  • directory_path (Field3) — varchar(300) — NOT NULL — 저장패스
  • table_id (Field4) — int — NOT NULL — 테이블아이디

Damoyeo_Meetup (모임테이블)

  • meetup_id — int — Primary key — NOT NULL — Key
  • meetup_name — varchar(100) — NOT NULL — 소모임명
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 모임마스터
  • view_count — int — NOT NULL — 조회수
  • max_user_count — int — NOT NULL — 최대설정인원
  • use_tf — CHAR(1) — NOT NULL — 사용여부
  • reg_date — datetime — NOT NULL — 생성일
  • meetup_image — varchar(120) — NOT NULL — 메인이미지
  • meetup_description — varchar(MAX) — NOT NULL — 모임설명
  • category_id — int — Foreign key → Damoyeo_Category.category_id — NOT NULL — key
  • phone_number — varchar(13) — NOT NULL — 핸드폰번호
  • email — varchar(60) — NOT NULL — 이메일
  • meeting_intro — varchar(200) — NOT NULL — 간략소개
  • person_name — varchar(50) — NOT NULL — 담당자명
  • meeting_sdate — varchar(10) — NOT NULL — 모임시작일
  • meeting_edate — varchar(10) — NOT NULL — 모임종료일
  • application_sdate — varchar(10) — NOT NULL — 모임신청시작일
  • application_edate — varchar(10) — NOT NULL — 모임신청종료일
  • kakao_openchat_link — varchar(200) — 카카오오픈챗
  • post_code — varchar(5) — NOT NULL — 우편번호
  • post_name — varchar(100) — NOT NULL — 우편주소지명
  • post_detail — varchar(200) — NOT NULL — 상세주소
  • over_capacity — char(1) — NOT NULL — 추가신청여부
  • meetup_display — char(1) — NOT NULL — 모임노출여부
  • bname — varchar(50) — NOT NULL — 법정동여부
  • longitude — varchar(50) — NOT NULL — 경도
  • latitude — varchar(50) — NOT NULL — 위도

Damoyeo_Meetup_Tags (태그, 소모임 매핑테이블)

  • Key — Primary key — NOT NULL
  • meetup_id — int — Foreign key → Damoyeo_Meetup.meetup_id — NOT NULL — Key
  • tag_id (Key2) — int — Foreign key → Damoyeo_Tags.tag_id — NOT NULL

Damoyeo_Notice (공지사항테이블)

  • board_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 키
  • title — varchar(100) — NOT NULL — 텍스트
  • content — text — NOT NULL — 내용
  • use_tf — char(1) — NOT NULL — 게시일
  • post_date — datetime — NOT NULL — 등록일
  • view_count — int — NOT NULL — 조회수

Damoyeo_Tags (태그)

  • tag_id (Key) — int — Primary key — NOT NULL
  • tag_name (Field) — varchar(100) — NOT NULL — 태그명

Damoyeo_User (회원테이블)

  • user_id — int — Primary key — NOT NULL — 키
  • email — VARCHAR(60) — NOT NULL — 이메일
  • password — VARCHAR(64) — NOT NULL — 비밀번호
  • profile_image — VARCHAR(120) — 이미지
  • slf_Intro — VARCHAR(255) — 자기소개
  • nickname — VARCHAR(60) — 닉네임
  • use_tf — CHAR(1) — NOT NULL — 사용여부
  • reg_date — DATETIME — NOT NULL — 가입일
  • signup_type — CHAR(1) — NOT NULL — 회원가입 타입
  • stop_tf — CHAR(1) — NOT NULL — 정지여부

Damoyeo_User_InterestCategory (회원 관심카테고리)

  • Interest_id (Key) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 키
  • category_id — int — Foreign key → Damoyeo_Category.category_id — NOT NULL — key

Damoyeo_Wishlist (위시리스트)

  • wish_id (application_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → Damoyeo_User.user_id — NOT NULL — 키
  • meetup_id — int — Foreign key → Damoyeo_Meetup.meetup_id — NOT NULL — Key
  • wish_date (application_date) — datetime — NOT NULL — 등록일자