2

테이블 (8)

category

  • category_no — BIGINT(20) — 기본 키 — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

event

  • event_id — BIGINT(20) — 기본 키 — NOT NULL
  • group_id — BIGINT(20) — NOT NULL
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)

group

  • group_no — BIGINT(20) — 기본 키 — NOT NULL
  • group_name — VARCHAR(50) — NOT NULL
  • group_desc — VARCHAR(255)
  • created_date — DATETIME — NOT NULL
  • members_count — INT — NOT NULL
  • category_no — BIGINT(20) — 외래 키 → category.category_no — NOT NULL
  • hobby_no — BIGINT(20) — 외래 키 → hobby.hobby_no — NOT NULL

hobby

  • hobby_no — BIGINT(20) — 기본 키 — NOT NULL
  • hobby_name — VARCHAR(255) — NOT NULL

my_page

  • my_page_id — BIGINT(20) — 기본 키 — NOT NULL
  • user_no — BIGINT(20) — 외래 키 → user.user_no — NOT NULL
  • hobby_no — BIGINT(20) — 외래 키 → hobby.hobby_no
  • fav_category — VARCHAR(50) — NOT NULL
  • fav_hobby — BIGINT(20) — NOT NULL
  • fav_group — BIGINT(20) — NOT NULL

user

  • user_no — BIGINT(20) — 기본 키 — NOT NULL
  • user_id — VARCHAR(30) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone_no — VARCHAR(11) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • birthday — DATETIME
  • created_date — DATETIME — NOT NULL

user_group

  • user_no — BIGINT(20) — 외래 키 → user.user_no — NOT NULL
  • group_no — BIGINT(20) — 외래 키 → group.group_no — NOT NULL
  • join_date — DATETIME — NOT NULL

게시글

  • post_id — VARCHAR(50) — 기본 키 — NOT NULL
  • group_id — BIGINT(20) — 외래 키 → group.group_no — NOT NULL
  • author_id — BIGINT(20) — 외래 키 → user.user_no — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • created_date — DATETIME — NOT NULL