Algostudy
Tables (20)
HASHTAG (해시태그)
- Id (PK) — Long — Primary key — NOT NULL
- team_id (팀 ID) — Long — Foreign key → TEAM.id — NOT NULL
- name (이름) — String
INVITATION MESSAGE (초대 메시지)
- id (PK) — Long — Primary key — NOT NULL
- team_id (팀 ID) — Long — Foreign key → TEAM.id — NOT NULL
- message (메시지) — String — NOT NULL
- valid (유효성) — String — NOT NULL
INVITE_TEAM_MEMBER (초대 회원)
- id (PK) — Long — Primary key — NOT NULL
- member_id (회원 ID) — Long — Foreign key → MEMBER.id — NOT NULL
- team_id (팀 ID) — Long — Foreign key → TEAM.id — NOT NULL
Image (이미지)
- id (PK) — Long — Primary key — NOT NULL
- image_path (이미지 경로) — String
- image_url (이미지 URL) — String
MEMBER (회원)
- id (PK) — Long — Primary key — NOT NULL
- team_id (팀 ID) — Long — Foreign key → TEAM.id — NOT NULL
- username (회원명) — String
- email (이메일) — String
- password (비밀번호) — String
- boj_id (백준 ID) — String
- oauth2_id (oAuth ID) — String
MEMBER_ROLE (회원_권한)
- id (PK) — Long — Primary key — NOT NULL
- member_id (회원 ID) — Long — Foreign key → MEMBER.id — NOT NULL
- role_id (권한 ID) — Long — Foreign key → ROLE.id — NOT NULL
MESSAGE (메시지)
- id (PK) — Long — Primary key — NOT NULL
- member_id (회원 ID) — Long — Foreign key → MEMBER.id — NOT NULL
- send_date_time (전송시간) — TIMESTAMP
MISSION (미션)
- id (PK) — Long — Primary key — NOT NULL
- Field
MISSION_CALANDER (미션_달력)
- id (PK) — Long — Primary key — NOT NULL
- member_id (회원 ID) — Long — Foreign key → MEMBER.id — NOT NULL
- date (날짜) — TIMESTAMP
- success_yn (성패여부) — String
Posting_Mission (Untitled10)
RESOURCE (자원)
- id (PK) — Long — Primary key — NOT NULL
- resource_name (자원 이름) — String
- order_num (권한 가중치) — Int
ROLE (권한)
- id (PK) — Long — Primary key — NOT NULL
- role_name (권한 이름) — String
- role_desc (권한 설명) — String
ROLE_HIERARCHY (권한_계층)
- id (PK) — Long — Primary key — NOT NULL
- parent_id (부모 권한) — Long — Foreign key → ROLE_HIERARCHY.id — NOT NULL
- child_name (자손 권한 이름) — String
ROLE_RESOURCE (권한_자원)
- id (PK) — Long — Primary key — NOT NULL
- resource_id (자원 ID) — Long — Foreign key → RESOURCE.id — NOT NULL
- role_id (권한 ID) — Long — Foreign key → ROLE.id — NOT NULL
Streaming_Mission (Untitled11)
TEAM (팀)
- id (PK) — Long — Primary key — NOT NULL
- admin_member_id (관리자 회원 ID) — Long — Foreign key → MEMBER.id — NOT NULL
- main_image_id (이미지) — Long — Foreign key → Image.id — NOT NULL
- team_name (팀명) — String
- team_desc (팀 설명) — String
- status (팀 상태) — String
- start_date_time (시작일) — Timestamp
- end_date_time (종료일) — Timestamp
- study_url (접근 URL) — String
TEAM_MISSION (팀 미션)
- id (PK) — Long — Primary key — NOT NULL
- mission_id (미션 ID) — Long — Foreign key → MISSION.id — NOT NULL
- team_id (팀 ID) — Long — Foreign key → TEAM.id — NOT NULL