cms

Tables (19)

tb_article

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • content — OID — 본문
  • title — CHARACTER — 제목
  • visibility — CHARACTER — 공개여부
  • category_id — CHARACTER — Foreign key → tb_category.id — 카테고리

tb_article_attachment

  • attachment_id — CHARACTER — Foreign key → tb_attachment.id — NOT NULL
  • article_id — CHARACTER — Foreign key → tb_article.id — NOT NULL

tb_article_vote

  • vote_id — CHARACTER — Foreign key → tb_vote.id — NOT NULL
  • article_id — CHARACTER — Foreign key → tb_article.id — NOT NULL

tb_attachment

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • mime_type — CHARACTER — MIME
  • name — CHARACTER — 이름
  • original_name — CHARACTER — 원본이름
  • path_name — CHARACTER — 경로명
  • size — BIGINT — NOT NULL — 크기

tb_authority

  • id — CHARACTER — NOT NULL
  • alias — CHARACTER — 별칭
  • name — CHARACTER — 이름

tb_category

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • description — CHARACTER — 설명
  • name — CHARACTER — 이름
  • type — CHARACTER — 타입
  • visibility — CHARACTER — 공개여부
  • parent_id — CHARACTER — Foreign key → tb_category.id — 부모
  • site_id — CHARACTER — Foreign key → tb_site.id — 사이트

tb_menu

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • name — CHARACTER — 이름
  • sequence — INTEGER — 순번
  • uri — CHARACTER — URI
  • parent_id — CHARACTER — Foreign key → tb_menu.id — 부모

tb_menu_authority

  • menu_id — CHARACTER — Foreign key → tb_menu.id — NOT NULL
  • authority_id — CHARACTER — Foreign key → tb_authority.id — NOT NULL

tb_notification

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • type — CHARACTER — 유형
  • category_id — CHARACTER — Foreign key → tb_category.id — 카테고리

tb_remember_me_token

  • series — CHARACTER — NOT NULL
  • last_used — TIMESTAMP(6) — NOT NULL
  • token — CHARACTER — NOT NULL
  • username — CHARACTER — NOT NULL

tb_reply

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • content — OID — 본문
  • visibility — CHARACTER — 공개여부
  • article_id — CHARACTER — Foreign key → tb_article.id — 게시글
  • parent_id — CHARACTER — Foreign key → tb_reply.id — 상위

tb_reply_attachment

  • attachment_id — CHARACTER — Foreign key → tb_attachment.id — NOT NULL
  • reply_id — CHARACTER — Foreign key → tb_reply.id — NOT NULL

tb_reply_vote

  • reply_id — CHARACTER — Foreign key → tb_reply.id — NOT NULL
  • vote_id — CHARACTER — Foreign key → tb_vote.id — NOT NULL

tb_site

  • id — CHARACTER — NOT NULL
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • description — CHARACTER — 설명
  • introduction — CHARACTER — 소개
  • name — CHARACTER — 이름
  • type — CHARACTER — 타입
  • visibility — CHARACTER — 공개여부
  • parent_id — CHARACTER — Foreign key → tb_site.id — 부모

tb_site_attachment

  • site_id — CHARACTER — Foreign key → tb_site.id — NOT NULL
  • attachment_id — CHARACTER — Foreign key → tb_attachment.id — NOT NULL

tb_user

  • id — CHARACTER — NOT NULL
  • first_contact_number — CHARACTER — 연락처
  • last_contact_number — CHARACTER — 연락처
  • middle_contact_number — CHARACTER — 연락처
  • created_date — TIMESTAMP(6) — 생성
  • credentials_expired_date — TIMESTAMP(6) — 패스워드
  • email_domain — CHARACTER — 이메일
  • email_id — CHARACTER — 이메일
  • expired_date — TIMESTAMP(6) — 만료
  • last_modified_date — TIMESTAMP(6) — 수정
  • locked_date — TIMESTAMP(6) — 잠금
  • name — CHARACTER — 이름
  • password — CHARACTER — 패스워드
  • username — CHARACTER — NOT NULL — 계정명

tb_user_authority

  • user_id — CHARACTER — Foreign key → tb_user.id — NOT NULL
  • authority_id — CHARACTER — Foreign key → tb_authority.id — NOT NULL

tb_view

  • id — CHARACTER — NOT NULL — 식별자
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • article_id — CHARACTER — Foreign key → tb_article.id

tb_vote

  • id — CHARACTER — NOT NULL — 식별자
  • created_by — CHARACTER — 생성자
  • created_date — TIMESTAMP(6) — 생성일시
  • last_modified_by — CHARACTER — 수정자
  • last_modified_date — TIMESTAMP(6) — 수정일시
  • type — CHARACTER