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)