tigen-intern

Tables (3)

member

  • 아이디 (USER_ID) — varchar(255) — Primary key — NOT NULL
  • 비밀번호 (USER_PW) — varchar(255) — NOT NULL
  • 닉네임 (USERNAME) — varchar(255) — NOT NULL
  • 활성상태 (ENABLED) — char(1) — NOT NULL
  • 권한 (AUTH) — varchar(255) — NOT NULL
  • 디바이스토큰 (TARGET_TOKEN) — varchar(255)

message

  • 메세지번호 (MESSAGE_ID) — int (auto increment) — Primary key — NOT NULL
  • 제목 (TITLE) — varchar(255) — NOT NULL
  • 내용 (CONTENT) — text — NOT NULL
  • 작성날짜 (CREATION_DATE) — varchar(255) — NOT NULL
  • 체크여부 (CHECK_TYPE) — varchar(255) — NOT NULL
  • 작성자 (CREATION_USER) — varchar(255) — Foreign key → member.아이디 — NOT NULL

receiver

  • 수신자구별번호 (RECEIVER_ID) — int (auto increment) — Primary key
  • 보내는메세지번호 (SEND_MESSAGE_ID) — int — Foreign key → message.메세지번호 — NOT NULL
  • 수신자아이디 (RECEIVER_NAME) — varchar(255) — Foreign key → member.아이디 — NOT NULL