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)