mytrip
Tables (20)
ALARM_SETTINGS_TB
- MEMBER_ID_FK_PK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_ID_PK — NOT NULL
- ALARM_SETTING_POST — INT
- ALARM_SETTING_COMMENT — INT
- ALARM_SETTING_CHAT — INT
- ALARM_SETTING_FOLLOW — INT
ALARM_TB
- ALARM_NUM_PK — INT — Primary key — NOT NULL
- ALARM_SENDER_ID — VARCHAR(20) — NOT NULL
- ALARM_CREATED_AT_DT — TIMESTAMP — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — NOT NULL
- ALARM_TYPE_ID_FK — INT — NOT NULL
- ALARM_IS_READ — INT — NOT NULL
- ALARM_ADDR — INT — NOT NULL
ALARM_TYPE_TB
- ALARM_TYPE_ID_PK — INT
- ALARM_TYPE_NAME — VARCHAR(50) — NOT NULL
- ALARM_TYPE_CONTENT — VARCHAR(255) — NOT NULL
BANK_SERVICE_TB
- BANK_SERVICE_NUM_PK — INT — Primary key — NOT NULL
- BANK_NUM_FK — VARCHAR(30) — Foreign key → BANK_TB.BANK_NUM_PK — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_ID_PK — NOT NULL
- BANK_SERVICE_TYPE — VARCHAR(2) — NOT NULL
- BANK_SERVICE_MONEY — INT — NOT NULL
- BANK_PERSONAL_TOTAL — INT — NOT NULL
- BANK_UPDATE_DT — TIMESTAMP — NOT NULL
- BANK_TOTAL — INT — NOT NULL
BANK_TB
- BANK_NUM_PK — VARCHAR(30) — Primary key — NOT NULL
- CHATROOM_NUM_FK — INT — Foreign key → CHAT_ROOM_TB.CHATROOM_NUM_PK — NOT NULL
- BANK_NAME — VARCHAR(50) — NOT NULL
- BANK_TOTAL_MONEY — INT — NOT NULL
- BANK_TARGET_MONEY — INT — NOT NULL
- BANK_TARGET_CHECK — VARCHAR(10) — NOT NULL
BOARD_TAG_TB
- BOARD_TAG_NUM_PK — INT — Primary key — NOT NULL
- BOARD_NUM_FK — INT — Foreign key → BOARD_TB.BOARD_NUM_PK — NOT NULL
- TAG_NUM_FK — INT — NOT NULL
BOARD_TB
- BOARD_NUM_PK — INT — Primary key — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_ID_PK — NOT NULL
- BOARD_TITLE — VARCHAR(100) — NOT NULL
- BOARD_CONTENT — TEXT
- BOARD_DT — TIMESTAMP — NOT NULL
- BOARD_OPEN — INT — NOT NULL
- BOARD_CNT — INT — NOT NULL
- BOARD_CATEGORY — INT — NOT NULL
- BOARD_LIKES — INT — NOT NULL
- BOARD_REPLY_CNT — INT — NOT NULL
BOOKMARK_TB
- BOOKMARK_NUM_PK — INT — Primary key — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — NOT NULL
- BOARD_NUM_FK — INT — Foreign key → BOARD_TB.BOARD_NUM_PK — NOT NULL
- BOOKMARK_STATUS — INT — NOT NULL
- BOOKMARK_CREATE_DT — TIMESTAMP — NOT NULL
CHAT_MEMBER_TB
- CHATROOM_NUM_FK_PK — INT — Foreign key → CHAT_ROOM_TB.CHATROOM_NUM_PK — NOT NULL
- MEMBER_ID_FK_PK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_ID_PK — NOT NULL
- CHATMEMBER_ENTER_DT — TIMESTAMP — NOT NULL
- CHATMEMBER_LEAVE_DT — TIMESTAMP
- CHATMEMBER_ROLE — VARCHAR(20) — NOT NULL
CHAT_ROOM_TB
- CHATROOM_NUM_PK — INT — Primary key — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_ID_PK — NOT NULL
- CHATROOM_NAME — VARCHAR(30) — NOT NULL
- CHATROOM_LAST_CHAT — TIMESTAMP — NOT NULL
FOLLOW_TB
- FOLLOW_NUM_PK — INT — Primary key — NOT NULL
- FOLLOWER_ID_FK — VARCHAR(20) — NOT NULL
- FOLLOWING_ID_FK — VARCHAR(20) — NOT NULL
- FOLLOW_CREATED_AT — TIMESTAMP — NOT NULL
LIKE_TB
- LIKE_NUM_PK — INT — Primary key — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — NOT NULL
- BOARD_NUM_FK — INT — Foreign key → BOARD_TB.BOARD_NUM_PK — NOT NULL
- LIKE_DT — TIMESTAMP — NOT NULL
MAP_TB
- MARKER_NUM_PK — INT — Primary key — NOT NULL
- BOARD_NUM_FK — INT — Foreign key → BOARD_TB.BOARD_NUM_PK — NOT NULL
- MARKER_LATITUDE — DECIMAL(10, 6) — NOT NULL
- MARKER_LONGITUDE — DECIMAL(10, 6) — NOT NULL
- MARKER_PLACE — VARCHAR(255)
MEMBER_TB
- MEMBER_ID_PK — VARCHAR(20) — Primary key — NOT NULL
- MEMBER_PWD — VARCHAR(30) — NOT NULL
- MEMBER_NAME — VARCHAR(20) — NOT NULL
- MEMBER_NICK — VARCHAR(30) — NOT NULL
- MEMBER_PHONE — VARCHAR(20) — NOT NULL
- MEMBER_EMAIL — VARCHAR(255) — NOT NULL
- MEMBER_LEVEL — VARCHAR(30) — NOT NULL
- MEMBER_BANK — VARCHAR(20)
- MEMBER_PROFILE — VARCHAR(100) — NOT NULL
- MEMBER_TEST_RESULT — VARCHAR(30)
- MEMBER_STATUS — VARCHAR(20) — NOT NULL
MESSAGE_TB
- MESSAGE_NUM_PK — INT — Primary key — NOT NULL
- CHATROOM_NUM_FK — INT — Foreign key → CHAT_ROOM_TB.CHATROOM_NUM_PK — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_ID_PK — NOT NULL
- MESSAGE_DT — TIMESTAMP — NOT NULL
- MESSAGE — VARCHAR(250) — NOT NULL
- MESSAGE_TYPE — VARCHAR(20) — NOT NULL
REPLY_TB
- REPLY_NUM_PK — INT — Primary key — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — NOT NULL
- BOARD_NUM_FK — INT — NOT NULL
- REPLY_CONTENT — VARCHAR(5000) — NOT NULL
- REPLY_DT — TIMESTAMP — NOT NULL
- PARENT_NUM — INT — Foreign key → REPLY_TB.REPLY_NUM_PK — NOT NULL
SETTLEMENT_SERVICE_TB
- SETTLEMENT_SERVICE_NUM_PK — INT — Primary key — NOT NULL
- SETTLEMENT_SENDER_NICK_FK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_NICK — NOT NULL
- SETTLEMENT_NUM_FK — INT — Foreign key → SETTLEMENT_TB.SETTLEMENT_NUM_PK — NOT NULL
SETTLEMENT_TB
- SETTLEMENT_NUM_PK — INT — Primary key — NOT NULL
- CHATROOM_NUM_FK — INT — Foreign key → CHAT_ROOM_TB.CHATROOM_NUM_PK — NOT NULL
- SETTLEMENT_TO_MEMBER_NICK_FK — VARCHAR(20) — Foreign key → MEMBER_TB.MEMBER_NICK — NOT NULL
- SETTLEMENT_MONEY — DECIMAL(10, 2) — NOT NULL
- SETTLEMENT_CHECK — INT — NOT NULL
TAG_TB
- TAG_NUM_PK — INT — Primary key — NOT NULL
- TAG_NAME — VARCHAR(20) — NOT NULL
- TAG_TYPE — INT
TIMELINE_TB
- TIMELINE_NUM_PK — INT — Primary key — NOT NULL
- BOARD_NUM_FK — INT — Foreign key → BOARD_TB.BOARD_NUM_PK — NOT NULL
- MEMBER_ID_FK — VARCHAR(20) — NOT NULL
- TIMELINE_START_DT — TIMESTAMP — NOT NULL
- TIMELINE_END_DT — TIMESTAMP — NOT NULL
- TIMELINE_TODO — VARCHAR(500) — NOT NULL
- TIMELINE_LOCATION — VARCHAR(255) — NOT NULL