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