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