CA4U

Tables (15)

album (길드_앨범)

  • album_id (Key2) — Primary key — NOT NULL
  • album_nm (Field)
  • cre_dt (Field2)
  • upd_dt (Field3)
  • guild_id (Key) — Foreign key → guild.guild_id — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL

album_photo (앨범_사진)

  • album_photo_id (Key) — Primary key — NOT NULL
  • album_id (Key2) — Foreign key → album.album_id — NOT NULL
  • photo_url (Field)
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL

article (게시글)

  • article_id (Key) — Primary key — NOT NULL
  • article_type (Field7)
  • article_nm (Field)
  • article_desc (Field11)
  • guild_id (Key2) — Foreign key → guild.guild_id — NOT NULL
  • cre_dt (Field3)
  • upd_dt (Field2)
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL

article_junk_report (신고_게시글)

  • article_junk_report_id (Key) — Primary key — NOT NULL
  • report_desc (Field)
  • article_id (Key2) — Foreign key → article.article_id — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL

article_photo (Untitled4)

  • article_photos_id (Key) — Primary key — NOT NULL
  • img_url (Field)
  • article_id (Key2) — Foreign key → article.article_id — NOT NULL

category (카테고리)

  • category_id (Key) — Primary key — NOT NULL
  • category_nm (카테고리이름)
  • parent_category_id (부모_카테고리) — Foreign key → category.category_id — NOT NULL
  • category_type (카테고리타입)
  • img_url (이미지주소)

guild (길드(동아리,학회))

  • guild_id (Key) — Primary key — NOT NULL
  • category_id (Key2) — Foreign key → category.category_id — NOT NULL
  • recruit_desc (Field11)
  • guild_nm (Field)
  • guild_brief_desc (Field2)
  • target_people_desc (Field3)
  • target_cycle_desc (Field4)
  • apply_desc (Field5)
  • act_day_desc (Field6)
  • location_desc (Field7)
  • guild_num (Field8)
  • cost_desc (Field9)
  • spec_desc (Field10)
  • logo_img_url (Field14)
  • cre_dt (Field12)
  • upd_dt (Field13)

guild_ thumbnail (길드_썸네일_이미지)

  • guild_thumbnail (Key) — Primary key — NOT NULL
  • cre_dt (Field)
  • upd_dt (Field2)
  • img_url (Field3)
  • guild_id (Key2) — Foreign key → guild.guild_id — NOT NULL

guild_hashtag (길드_태그들)

  • guild_hashtag_id (Key) — Primary key — NOT NULL
  • guild_id (Key2) — Foreign key → guild.guild_id — NOT NULL
  • hashtag_id (Key3) — Foreign key → hashtag.hashtag_id — NOT NULL

hashtag (태그)

  • hashtag_id (Key) — Primary key — NOT NULL
  • hashtag_nm (태그이름)
  • img_url (태그_이미지)

member (유저)

  • member_id (Key) — Primary key — NOT NULL
  • nickname (Field)
  • password (Field2)
  • email (Field3)
  • role (Field4)
  • img_url (Field5)

member_guild_cert (유저_길드_인증)

  • member_guild_cert_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • guild_id (Key3) — Foreign key → guild.guild_id — NOT NULL

member_guild_like (유저_길드_좋아요)

  • user_guild_id (Key) — Primary key — NOT NULL
  • guild_id (Key2) — Foreign key → guild.guild_id — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL

search_guild_tag (검색_길드_태그)

  • search_guild_tag_id (Key) — Primary key — NOT NULL
  • search_tag_id (Key2) — Foreign key → search_tag.search_tag_id — NOT NULL
  • guild_id (Key3) — Foreign key → guild.guild_id — NOT NULL

search_tag (검색태그)

  • search_tag_id (Key) — Primary key — NOT NULL
  • tag_nm (Field)