messageToGrobalFriend

Tables (5)

CHAT_ROOM (Untitled5)

  • id (CHATROOM_ID) — Long — Primary key — NOT NULL
  • id (MEMBER_ID) — Long — Foreign key → MEMBER_INFO.id — NOT NULL
  • id (MEMBER_ID2) — Long
  • 수락여부 — String
  • create_time — date
  • 수락시간 — date

MEMBER_ACCOUNT (Untitled2)

  • id — Long — Primary key — NOT NULL
  • id (MEMBER_ID) — Long — Foreign key → MEMBER_INFO.id — NOT NULL
  • Field (ACCOUNT) — String
  • password (PASSWORD) — String
  • create_date (CREATE_DATE) — Datetime
  • withdraw_date (WITHDRAW_DATE) — Datetime
  • withdraw_status (WITHDRAW_STATUS) — String

MEMBER_INFO (Untitled)

  • id (MEMBER_ID) — Long — Primary key — NOT NULL
  • name (MEMBER_NAME) — String
  • birthdate (MEMBER_BIRTHDATE) — String
  • grade (MEMBER_GRADE) — String
  • image_url (MEMBER_IMAGE_URL) — String
  • join_time (MEMBER_JOIN_DATE) — Datetime
  • update_time (MEMBER_UPDATE_DATE) — Datetime

MEMBER_SUBSCRIBE (Untitled3)

  • id — Long — Primary key — NOT NULL
  • id (MEMBER_ID) — Long — Foreign key → MEMBER_INFO.id — NOT NULL
  • item_name (ITEM_NAME) — String
  • purchase_date (PURCHASE_DATE) — Datetime
  • expire_date (EXPIRE_DATE) — Datetime

message (Untitled4)

  • id — Long — Primary key — NOT NULL
  • id (CHATROOM_ID2) — Long — Foreign key → CHAT_ROOM.id — NOT NULL
  • CHATROOM_ID — Long
  • MESSAGE_FROM — Long
  • MESSAGE_TO — Long
  • CONTENTC (CONTENT) — Text
  • send_date — datetime