board
Tables (5)
GroupCode (그룹코드)
- id (그룹코드ID) — integer — Primary key — NOT NULL
- gc_nm (그룹코드명) — varchar(20)
- create_at (등록일) — timestamp [(p)] with time zone
- update_at (수정일) — timestamp [(p)] with time zone
- writer (등록자) — varchar(20)
- modifier (수정자) — varchar(20)
SwiftCode (공통코드)
- id (공통코드ID) — integer — Primary key — NOT NULL
- gc_id (그룹코드ID) — integer — Foreign key → GroupCode.id — NOT NULL
- sc_nm (코드명) — varchar(20)
- create_at (등록일) — timestamp [(p)] with time zone
- update_at (수정일) — timestamp [(p)] with time zone
- writer (등록자) — varchar(20)
- modifier (수정자) — varchar(20)
posts (게시글)
- id (게시글ID) — integer — Primary key — NOT NULL
- user_id (회원ID) — integer — Foreign key → users.id — NOT NULL
- title (제목) — varchar(20)
- content (내용) — text
- status (상태) — integer
- create_at (등록일) — timestamp [(p)] with time zone
- update_at (수정일) — timestamp [(p)] with time zone
- writer (등록자) — varchar(20)
- modifier (수정자) — varchar(20)
replys (댓글)
- id (댓글ID) — integer — Primary key — NOT NULL
- user_id (회원ID) — integer — Foreign key → users.id — NOT NULL
- post_id (게시글ID) — integer — Foreign key → posts.id — NOT NULL
- content (내용) — varchar(20)
- parent_reply_id (부모댓글) — integer
- depth (댓글깊이) — integer
- reply_group (댓글그룹) — integer
- reply_order (댓글 순서) — integer
- stauts (상태) — integer
- create_at (생성일) — timestamp [(p)] with time zone
- update_at (수정일) — timestamp [(p)] with time zone
- writer (등록자) — varchar(20)
- modifier (수정자) — varchar(20)
users (회원)
- id (회원ID) — integer — Primary key — NOT NULL
- username (아이디) — varchar(20)
- email (이메일) — varchar(20)
- password (비밀번호) — varchar(20)
- zipcode (우편번호) — integer
- street_adr (도로명주소) — varchar(20)
- detail_adr (상세주소) — varchar(20)
- role (권한) — varchar(20)
- create_at (등록일) — timestamp [(p)] with time zone
- update_at (수정일) — timestamp [(p)] with time zone
- writer (등록자) — varchar(20)
- modifier (수정자) — varchar(20)