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