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)