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