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