worldcup

Tables (6)

CATEGORY (카테고리)

  • CATEGORY_ID (Key) — Primary key — NOT NULL
  • NAME (Field)

GAME (게임 기록)

  • GAME_ID (Key) — Primary key — NOT NULL
  • WORLDCUP_ID (Key3) — Foreign key → WORLDCUP.WORLDCUP_ID — NOT NULL
  • TARGET_ID (Key4) — Foreign key → TARGET.TARGET_ID — NOT NULL
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL

IMAGE (이미지 URL)

  • IMAGE_ID (Key) — Primary key — NOT NULL
  • url (Field2)

MEMBER (회원)

  • MEMBER_ID (Key) — Primary key — NOT NULL
  • EMAIL (Field)
  • PASSWORD (Field2)
  • ROLE (Field3)
  • AGE (Field4)
  • GENDER (Field5)
  • AUTH_KEY (Field6)
  • AUTH_STATUS (Field7)
  • AUTH_EXPIRED (Field8)

TARGET (타겟)

  • TARGET_ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • LIKES_COUNT (Field2)
  • IMAGE_ID (FK) — Foreign key → IMAGE.IMAGE_ID — NOT NULL
  • WORLDCUP_ID (Key2) — Foreign key → WORLDCUP.WORLDCUP_ID — NOT NULL

WORLDCUP (월드컵 게임)

  • WORLDCUP_ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • RECOMMEND_COUNT (Field2)
  • CREATE_DATE (Field3)
  • DESCRIPTION (Field4)
  • CATEGORY_ID (Key3) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • MEMBER_ID (Key2) — Foreign key → MEMBER.MEMBER_ID — NOT NULL