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)