SNUBASEBALL

Tables (6)

DAILY_TAG (날짜별 태그)

  • TAG_ID (Key) — Primary key — NOT NULL
  • CONTENT (내용)

DETAIL_TAG (시간별 태그)

  • DETAIL_TAG (Key) — Primary key — NOT NULL
  • CONTENT (내용)

PARTICIPATE (훈련참가)

  • USER_ID (아이디) — Foreign key → USER.USER_ID — NOT NULL
  • TIMESLOT_ID (Key2) — Foreign key → TIMESLOT.TIMESLOT_ID — NOT NULL

TIMESLOT (Untitled2)

  • TIMESLOT_ID (Key) — Primary key — NOT NULL
  • DATE (날짜)
  • DAY (요일)
  • START (시작시간)
  • END (종료시간)

USER (사용자)

  • USER_ID (아이디) — Primary key — NOT NULL
  • PASSWORD (비밀번호)
  • PHONE_NUMBER (전화번호)
  • ROLE (역할)

USERPROFILE (유저프로필)

  • PROFILE_ID (Key) — Primary key — NOT NULL
  • name (이름)
  • grade (학년)
  • major (전공)
  • position (포지션)
  • pitcher (투타)
  • USER_ID (아이디) — Foreign key → USER.USER_ID — NOT NULL