carrot
Tables (5)
article (Untitled)
- atc_id (Key) — bigint(20) — Primary key — NOT NULL
- member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
- atc_title (Field) — varchar(128) — NOT NULL
- atc_content (Field2) — varchar(128) — NOT NULL
- atc_status (Field3) — enum — NOT NULL — 모집 상태 여부
- atc_category (Field4) — enum — NOT NULL
- atc_area (Field7) — varchar(128) — NOT NULL
- date_created (Field8) — varchar(128) — NOT NULL
- date_updated (Field9) — varchar(128) — NOT NULL
- reply_count (Field5) — int — NOT NULL
article_image (Untitled3)
- article_image_id (Key) — bigiint — Primary key — NOT NULL
- atc_id (member_id) — bigint(20) — Foreign key → article.member_id — NOT NULL
- article_image_url (Field) — varchar(128) — NOT NULL
comment (Untitled2)
- cmt_id (Key) — bigint(20) — Primary key — NOT NULL
- atc_id (Key2) — bigint(20) — Foreign key → article.atc_id — NOT NULL — 게시물 의 PK
- cmt_content (Field3) — varchar(128) — NOT NULL
- cmt_date_created (Field4) — varchar(128) — NOT NULL
- cmt_date_updated (Field5) — varchar(128) — NOT NULL
- member_id — bigint(20) — Foreign key → member.member_id — NOT NULL — 댓글 입력한 회원의 PK
festival (Untitled5)
- fstvl_id (Key) — Primary key — NOT NULL
- fstvl_name (Field) — NOT NULL — 축제명
- fstvl_loc (Field2) — NOT NULL — 개최장소
- fstvl_date_start (Field3) — NOT NULL — 축제 시작일
- fstvl_date_end (Field4) — NOT NULL — 축제 종료일
- fstvl_detail (Field5) — NOT NULL — 축제 상세
- fstvl_loc_detail (Field6) — 개최도로명주소
member
- member_id — bigint(20) — Primary key — NOT NULL
- mem_email (Field) — varchar(128) — NOT NULL
- mem_password (Field2) — varchar(128) — NOT NULL
- mem_nickname (Field3) — varchar(128) — NOT NULL
- role (Field4) — enum — NOT NULL
- mem_area (Field5) — varchar(128) — NOT NULL
- mem_image_url (Field6) — varchar(128)