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