Algostudy

Tables (20)

Boj_Mission (Untitled9)

    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

    Penalty (Untitled13)

      Posting_Mission (Untitled10)

        Postings (Untitled12)

          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