blaA

Tables (17)

Alarm (알림)

  • alarm_pk — INT — Primary key — NOT NULL
  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • alarm_text (Field) — VARCHAR(20)

ArticlePicture (게시글사진)

  • aritcle_pk — INT — Foreign key → CrewArticle.aritcle_pk — NOT NULL
  • article_picture (게시글 사진) — FILE

Blacklist (신고)

  • blacklist_pk — INT — Primary key — NOT NULL
  • user_pk (신고대상) — INT — Foreign key → User.user_pk — NOT NULL
  • black_content (신고내용) — VARCHAR(50) — NOT NULL
  • black_reason (신고사유) — VARCHAR(20) — NOT NULL

Crew (크루)

  • crew_pk — INT — Primary key — NOT NULL
  • crew_leader (크루리더) — INT — Foreign key → User.user_pk — NOT NULL
  • is_business (영업용 여부) — BOOLEAN — NOT NULL
  • crew_name (크루명) — VARCHAR(50) — NOT NULL
  • crew_address (크루주소)
  • crew_img (크루 사진) — FILE
  • crew_explain (크루 설명) — VARCHAR(200)

CrewArticle (크루 게시판)

  • aritcle_pk — INT — Primary key — NOT NULL
  • crew_pk — INT — Foreign key → Crew.crew_pk — NOT NULL
  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • crew_title (제목) — VARCHAR(50) — NOT NULL
  • crew_content (게시물 내용) — VARCHAR(200) — NOT NULL
  • created_at (게시물 작성시간) — DATETIME — NOT NULL
  • crew_private (공지사항 공개여부) — BOOLEAN — NOT NULL
  • crew_pin (상단고정게시물) — BOOLEAN

CrewArticleComment (CopyOf스토리댓글)

  • crew_comment_pk — INT — Primary key — NOT NULL
  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • aritcle_pk — INT — Foreign key → CrewArticle.aritcle_pk — NOT NULL
  • crew_pk — INT — Foreign key → CrewArticle.crew_pk — NOT NULL
  • article_comment (게시물 댓글) — VARCHAR(50)
  • created_at (댓글작성시간) — DATETIME

CrewSchedule (크루스케쥴)

  • crew_schedule_pk (Key) — INT — Primary key — NOT NULL
  • crew_pk — INT — Foreign key → Crew.crew_pk — NOT NULL
  • user_pk — INT — Foreign key → Crew.crew_leader — NOT NULL
  • crew_day (날짜) — DATETIME — NOT NULL
  • color (색상) — VARCHAR(20) — NOT NULL
  • crew_starthour (시작시간) — TIME — NOT NULL
  • crew_endhour (종료시간) — TIME — NOT NULL

Follow (Untitled)

  • follow_pk (pk) — Primary key — NOT NULL
  • user_pk (from_user_pk) — INT — Foreign key → User.user_pk — NOT NULL
  • user_pk (to_user_pk) — INT — Foreign key → User.user_pk — NOT NULL

Hashtag (해시태그)

  • hashtag_pk (Key) — INT — Primary key — NOT NULL
  • story_pk — INT — Foreign key → Story.story_pk — NOT NULL
  • user_pk — INT — Foreign key → Story.user_pk — NOT NULL
  • hasgtag_content (해시태그) — VARCHAR(20) — NOT NULL

Review (리뷰)

  • review_pk — INT — Primary key — NOT NULL
  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • store_pk (strore_pk) — Foreign key → Store.store_pk — NOT NULL
  • star (별점) — INT — NOT NULL
  • oneline_review (한줄리뷰) — VARCHAR(100)
  • button_review (버튼리뷰) — VARCHAR(20) — NOT NULL

Review_like (리뷰 좋아요)

  • review_pk — INT — Foreign key → Review.review_pk — NOT NULL
  • user_pk (user_pk2) — INT — Foreign key → User.user_pk — NOT NULL

Store (가게 정보)

  • store_pk — INT — Primary key — NOT NULL
  • name (상호명) — VARCHAR(20) — NOT NULL
  • image (로고) — VARCHAR(20)
  • region (검색명) — VARCHAR(20) — NOT NULL

Story (스토리)

  • story_pk — INT — Primary key — NOT NULL
  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • stroy_title (오출완제목) — VARCHAR(50) — NOT NULL
  • story_picture (오출완사진) — FILE — NOT NULL
  • created_at (오출완작성시간) — DATETIME — NOT NULL
  • region (유저지역) — VARCHAR(20) — NOT NULL
  • category (유저업종) — VARCHAR(20) — NOT NULL

Story_comments (스토리댓글)

  • comment_pk — INT — Primary key — NOT NULL
  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • story_pk — INT — Foreign key → Story.story_pk — NOT NULL
  • story_comment (스토리댓글내용) — VARCHAR(50)
  • created_at (스토리댓글작성시간) — DATETIME

Story_like (오출완 좋아요)

  • story_pk — INT — Foreign key → Story.story_pk — NOT NULL
  • user_pk (user_pk2) — INT — Foreign key → User.user_pk — NOT NULL

User (사용자)

  • user_pk — INT — Primary key — NOT NULL
  • email (유저이메일) — EMAIL — NOT NULL
  • password (유저비밀번호) — PASSWORD — NOT NULL
  • tel (유저전화번호) — VARCHAR(15) — NOT NULL
  • name (유저실명) — VARCHAR(50) — NOT NULL
  • nickname (유저닉네임) — VARCHAR(20) — NOT NULL
  • region (유저지역) — VARCHAR(20)
  • category (유저업종) — VARCHAR(10)
  • is_alba (유저알바유무) — BOOLEAN — NOT NULL
  • image (유저 프로필 사진) — FILE
  • report (신고 횟수) — INT — NOT NULL

User-Crew (유저-크루)

  • user_pk — INT — Foreign key → User.user_pk — NOT NULL
  • crew_pk — INT — Foreign key → Crew.crew_pk — NOT NULL