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