무우럭

테이블 (11)

bbs

  • bbs_no — int — 기본 키 — NOT NULL
  • bbs_title — varchar(100) — NOT NULL
  • bbs_content — text — NOT NULL
  • bbs_img — varchar(100)
  • community_no — int — 외래 키 → community.community_no — NOT NULL
  • member_no — int — 외래 키 → member.member_no — NOT NULL

bookmark

  • bookmark_no — int — 기본 키 — NOT NULL
  • bbs_no — int — 외래 키 → bbs.bbs_no — NOT NULL
  • member_no — int — 외래 키 → member.member_no — NOT NULL

business

  • business_no — int — 기본 키 — NOT NULL — 게시판 번호
  • business_title — varchar(200) — NOT NULL — 게시글제목
  • business_date — datetime — NOT NULL — 게시한 시간
  • business_write — mediumtext — 작성한 글
  • business_image — varchar(200) — 이미지
  • business_place — varchar(200) — 거래장소
  • member_no — int — 외래 키 → member.member_no — NOT NULL — member테이블의 id
  • business_choose — tinyint(1) — 예약중 표기
  • business_share — tinyint(1) — NOT NULL — 나눔,거래?

calendar

  • calendar_id — int — 기본 키 — NOT NULL
  • member_no — int — 외래 키 → member.member_no — NOT NULL
  • calendar_start — varchar(100)
  • calendar_end — varchar(100)
  • calendar_title — varchar(100) — NOT NULL
  • calendar__mood — varchar(100)
  • created_at — timestamp

card

  • card_no — int — 기본 키 — NOT NULL
  • card_name — varchar(100) — NOT NULL — 식물 이름
  • card_species — varchar(100) — NOT NULL — 종
  • card_birth — date — NOT NULL — 반려일
  • card_mmti — varchar(100) — NOT NULL — 식물 성향
  • card_img — varchar(200) — NOT NULL — 사진 첨부
  • card_date — timestamp — NOT NULL — 발급일

community

  • community_no — int — 기본 키 — NOT NULL
  • community_category — varchar(100) — NOT NULL

diary

  • diary_no — int — 기본 키 — NOT NULL
  • diary_img — varchar(300)
  • diary_nickname — varchar(100) — NOT NULL
  • diary_title — varchar(300) — NOT NULL
  • diary_contents — varchar(500) — NOT NULL
  • diary_mood — varchar(100)
  • diary_date — datetime — NOT NULL
  • member_no — int — 외래 키 → member.member_no
  • card_no — int — 외래 키 → card.card_no

follow

  • follow_no — int — 기본 키 — NOT NULL
  • follower_user — int — NOT NULL
  • following_user — int — NOT NULL
  • follow_date — date

heart

  • heart_no — int — 기본 키 — NOT NULL
  • bbs_no — int — 외래 키 → bbs.bbs_no — NOT NULL
  • member_no — int — 외래 키 → member.member_no — NOT NULL

member

  • member_no — int — 기본 키 — NOT NULL
  • member_id — varchar(100) — NOT NULL
  • member_pw — varchar(100)
  • member_email — varchar(100) — NOT NULL
  • member_name — varchar(100) — NOT NULL
  • member_tel — varchar(13) — NOT NULL
  • member_nickname — varchar(100) — NOT NULL
  • member_img — varchar(100) — NOT NULL
  • member_gender — varchar(100) — NOT NULL
  • member_birthyear — varchar(100)
  • member_manager — int

reply

  • reply_no — int — 기본 키 — NOT NULL
  • reply_content — varchar(100) — NOT NULL
  • bbs_no — int — 외래 키 → bbs.bbs_no — NOT NULL
  • member_no — int — 외래 키 → member.member_no — NOT NULL