ㅅㄷㄴㅅ

Tables (10)

board_node_links (게시판 노드 하이퍼링크)

  • 링크ID (board_node_link_id) — VARCHAR — Primary key — NOT NULL
  • 조직명 (organization_id) — VARCHAR
  • 본문에 표시되는 텍스트 (display_text)
  • 링크타입 (link_type)
  • 외부링크 (external_url)
  • 생성시간 (created_at)
  • 링크가 있는 노드 (source_node_id) — VARCHAR — Foreign key → board_nodes.노드ID — NOT NULL
  • 링크가 가리키는 노드 (target_node_id) — VARCHAR — Foreign key → board_nodes.노드ID — NOT NULL

board_nodes (게시판 노드)

  • 노드ID (board_node_id) — VARCHAR — Primary key — NOT NULL
  • 조직ID (organization_id) — VARCHAR
  • 부모노드ID (board_parent_node_id) — VARCHAR
  • 섹션ID (board_section_id) — VARCHAR — Foreign key → board_sections.섹션ID — NOT NULL
  • 제목 (board_title) — VARCHAR
  • 본문 (board_content) — LONGTEXT
  • 깊이 (depth) — INT
  • 정렬순서 (position) — INT
  • 생성자 (Field)
  • 생성시간 (Field2)
  • 업데이트시간 (Field3)
  • 삭제시간 (Field4)

board_sections (게시판 섹션)

  • 섹션ID (board_section_id) — VARCHAR — Primary key — NOT NULL
  • 이름 (board_section_name)
  • 조직명 (organization_id)
  • 설명 (description) — VARCHAR
  • 생성자Id (created_by) — VARCHAR
  • 생성시간 (created_at) — TIMESTAMP
  • 업데이트시간 (updated_at) — TIMESTAMP
  • 삭제시간 (deleted_at) — TIMESTAMP
  • Field

organizations (조직)

  • 조직ID (organizations_id) — VARCHAR — Primary key — NOT NULL
  • 조직명 (organizations_name)
  • 조직에 속해있는 유저ID (organizations_members_id) — VARCHAR — Foreign key → organizations-members.조직에 속해있는 유저ID — NOT NULL

organizations-members (조직별유저)

  • 조직에 속해있는 유저ID (organizations_members_id) — VARCHAR — Primary key — NOT NULL
  • 권한 (organizations_members_role) — VARCHAR
  • Field
  • 유저ID (user_id) — VARCHAR — Foreign key → users.유저ID — NOT NULL

plans (구독금액)

  • 구독금액ID (plans_id) — VARCHAR — Primary key — NOT NULL
  • 구독명 (plans_name) — VARCHAR
  • max_members — int
  • monthly_price (monthly_price_id) — VARCHAR
  • Field2

subscribe_plan (Untitled)

  • PKID (subscribe_plan_id) — INT — Primary key — NOT NULL
  • Field

subscription (유저구독테이블)

  • PkID (user_subscribe_id) — INT — Primary key — NOT NULL
  • 유저ID (user_id) — INT — Foreign key → users.유저ID — NOT NULL
  • PKID (subscribe_plan_id) — VARCHAR — Foreign key → subscribe_plan.PKID — NOT NULL
  • 구독상태 (status) — VARCHAR
  • 구독시작일자 (Field2)
  • 구독만료일자 (Field3)
  • Field4
  • Field5
  • 조직ID (organizations_id) — VARCHAR — Foreign key → organizations.조직ID — NOT NULL

subscriptions (구독)

  • 구독ID (subscriptions_id) — VARCHAR — Primary key — NOT NULL
  • status — VARCHAR
  • billing_date (billing_date_id) — VARCHAR
  • Field
  • 구독금액ID (plans_id) — VARCHAR — Foreign key → plans.구독금액ID — NOT NULL
  • 조직ID (organizations_id) — VARCHAR — Foreign key → organizations.조직ID — NOT NULL

users (유저)

  • 유저ID (user_id) — VARCHAR — Primary key — NOT NULL
  • 회원EMAIL (user_email) — VARCHAR
  • Field