toyVa

Tables (6)

ATTACHMENT (Untitled4)

  • ATTACH_ID — Primary key — NOT NULL
  • RAWNAME
  • RENAME
  • BELONG_TO
  • FILE_STATUS

BOARD (Untitled2)

  • BOARD_ID — Primary key — NOT NULL
  • BOARD_TITLE
  • BOARD_CONTENT
  • BOARD_WRITER
  • BOARD_TAGS
  • CREATEDATE
  • MODIFYDATE
  • VIEWCOUNT
  • IS_NOTICE
  • IS_DELETE

BOARD_LIKE (Untitled5)

  • BOARD_ID — Foreign key → BOARD.BOARD_ID — NOT NULL
  • MEMBER_ID — Foreign key → Member.MEMBER_ID — NOT NULL
  • LIKEDATE

DECLARE (Untitled6)

  • DECLARE_ID — Primary key — NOT NULL
  • DECLARE_BOARD_ID — Foreign key → BOARD.BOARD_ID — NOT NULL
  • DECLARANT_ID — Foreign key → Member.MEMBER_ID — NOT NULL
  • DECLARE_REASON
  • DECLARE_DATE
  • IS_ACCEPT

Member (Untitled)

  • MEMBER_ID — Primary key — NOT NULL
  • NICKNAME
  • IS_MANAGER
  • PROFILE_ATT
  • LAST_VISIT_DATE
  • PASSWORD

REPLY (Untitled3)

  • REPLY_ID — Primary key — NOT NULL
  • REPLY_CONTENT
  • REPLY_WRITER
  • REF_BOARD_ID — Foreign key → BOARD.BOARD_ID — NOT NULL
  • REF_REPLY_ID
  • CREATEDATE
  • MODIFYDATE
  • IS_DELETE