bookclub

Tables (3)

tbl_member (Untitled)

  • member_idx (인덱스) — int — Primary key — NOT NULL
  • user_id (아이디) — varchar
  • password (비밀번호) — varchar
  • name (이름) — varchar
  • phone_number (전화번호) — varchar
  • email (이메일) — varchar

tbl_mystudy (Untitled2)

  • study_idx (인덱스) — int — Primary key — NOT NULL
  • user_id (아이디) — varchar
  • title (제목) — varchar
  • content (내용) — varchar
  • display_status (노출여부) — varchar
  • display_start (공유시작일) — datetime
  • display_end (공유종료일) — datetime
  • reg_date (등록일) — datetime
  • share_people (공유할 사람) — varchar
  • hashtag (해시태그) — varchar
  • field (분야) — varchar
  • like (좋아요) — int
  • image (이미지) — varchar
  • user_id (게시글 아이디) — int — Foreign key → tbl_member.member_idx — NOT NULL

tbl_share (Untitled3)

  • share_idx (인덱스) — int — Primary key — NOT NULL
  • receive_id (공유 받은 아이디) — varchar
  • study_idx (게시글 인덱스) — int
  • share_id (공유 한 아이디) — varchar
  • receive_id (공유받은 아이디) — varchar — Foreign key → tbl_member.member_idx — NOT NULL
  • share_id (공유 아이디) — varchar — Foreign key → tbl_member.member_idx — NOT NULL
  • study_idx (게시글) — int — Foreign key → tbl_mystudy.study_idx — NOT NULL