tikdog

Tables (20)

ADOPTION_BOARD

  • BOARD_NO — NUMBER
  • STATUS — VARCHAR2(20)

BOARD

  • BOARD_NO — NUMBER
  • MEMBER_NO — NUMBER — NOT NULL
  • BOARD_STATUS — VARCHAR2(20)
  • BOARD_TITLE — VARCHAR2(255)
  • BOARD_CONTENT — CLOB
  • BOARD_LIKE — NUMBER
  • CREATED_AT — DATE
  • VIEWS — NUMBER
  • UPDATED_AT — DATE
  • TYPE_ID — NUMBER — NOT NULL
  • REPORT_COUNT — NUMBER
  • BOARD_STATE — VARCHAR2(20)

BOARD_IMG

  • IMG_NO — NUMBER
  • BOARD_NO — NUMBER — NOT NULL
  • IMG_NAME — VARCHAR2(255)

CHAT_MESSAGE

  • MESSAGE_NO — NUMBER
  • USER_NO — NUMBER — NOT NULL
  • CHAT_ROOM_NO — NUMBER — NOT NULL
  • CONTENT — CLOB
  • CREATED_AT — DATE

CHAT_ROOM

  • CHAT_ROOM_NO — NUMBER
  • USER_NO — NUMBER — NOT NULL
  • TARGET_USER_NO — NUMBER — NOT NULL
  • STATUS — VARCHAR2(20)

COMMENT

  • undefined_NO — NUMBER — NOT NULL
  • undefined_CONTENT — CLOB — NOT NULL
  • CREATED_AT — DATE
  • STATUS — VARCHAR2(20)
  • REPORT_COUNT — NUMBER

DOG

  • DOG_NO — NUMBER
  • USER_NO — NUMBER — NOT NULL
  • NAME — VARCHAR2(100)
  • BREED — VARCHAR2(100)
  • BIRTH_DATE — DATE
  • GENDER — CHAR(1)
  • PROFILE_IMG — VARCHAR2(255)
  • DESCRIPTION — CLOB

DOGINFO

  • INFO_NO — NUMBER
  • CONTENT — CLOB
  • IMAGE — VARCHAR2(255)

LIKE

  • LIKE_NO — NUMBER
  • USER_NO — NUMBER — NOT NULL
  • TYPE_ID — NUMBER — NOT NULL
  • CREATED_AT — DATE

LIKES

  • CREATED_AT — DATE
  • QUANTITY — NUMBER
  • DESCRIPTION — CLOB
  • STATUS — VARCHAR2(20)
  • TYPE_ID — NUMBER

MEMBER

  • MEMBER_NO — NUMBER
  • MEMBER_NAME — VARCHAR2(100)
  • MEMBER_NICKNAME — VARCHAR2(100)
  • MEMBER_TEL — VARCHAR2(15)
  • MEMBER_EMAIL — VARCHAR2(100)
  • MEMBER_PWD — VARCHAR2(100)
  • MEMBER_BIRTH — DATE
  • MEMBER_ADDRESS — VARCHAR2(255)
  • MEMBER_STATUS — CHAR(1)
  • ADMIN_AUTH — CHAR(1)
  • TOTAL_POINTS — NUMBER

MEMO

  • MEMO_NO — NUMBER
  • USER_NO — NUMBER — NOT NULL
  • CREATED_AT — DATE
  • CONTENT — CLOB

MISSING_BOARD

  • BOARD_NO — NUMBER
  • STATUS — VARCHAR2(20)

NOTIFICATION

  • NOTIFICATION_NO — NUMBER
  • TYPE_ID — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • CREATED_AT — DATE
  • CONTENT — CLOB
  • STATUS — VARCHAR2(20)

POINT

  • POINT_NO — NUMBER
  • USER_NO — NUMBER — NOT NULL
  • DESCRIPTION — CLOB
  • POINT — NUMBER
  • CREATED_AT — DATE
  • STATUS — CHAR(1)
  • TYPE_ID — NUMBER

POINT_ITEM

  • ITEM_NO — NUMBER
  • POINT_COST — NUMBER

REPLY

  • REPLY_NO — NUMBER
  • COMMENT_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — NOT NULL
  • CONTENT — CLOB
  • CREATED_AT — DATE
  • STATUS — VARCHAR2(20)
  • REPORT_COUNT — NUMBER

REPORT

  • REPORT_NO — NUMBER
  • CATEGORY — VARCHAR2(50)
  • CONTENT — CLOB
  • USER_NO — NUMBER — NOT NULL
  • TYPE_ID — NUMBER — NOT NULL
  • CREATED_AT — DATE

SECOND_HAND_BOARD

  • BOARD_NO — NUMBER
  • STATUS — VARCHAR2(20)

TYPE_TABLE

  • TYPE_ID — NUMBER
  • TYPE_NAME — VARCHAR2(50)