ㅅㄷㄴㅅ
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