ㅁㄴㅇ
Tables (5)
comment (댓글)
- commentId (Key) — BIGINT — Primary key — NOT NULL
- scheduleId (Key2) — BIGINT — Foreign key → schedule.scheduleId — NOT NULL
- userId (Key3) — BIGINT — Foreign key → user.userId — NOT NULL
- fileId (Key32) — BIGINT — Foreign key → schedule.fileId — NOT NULL
- content (Field) — VARCHAR
- date (Field3) — TIMESTAMP
file (이미지)
- fileId (Key) — BIGINT — Primary key — NOT NULL
- file_name (Field) — VARCHAR
- file_size (Field2) — INT
- file_type (Field3) — VARCHAR
- file_path (Field4) — VARCHAR
refresh_token (리프레쉬토큰)
- refreshTokenId (Key) — BIGINT — Primary key — NOT NULL
- refresh_token (Field) — VARCHAR
- date (Field2) — TIMESTAMP
schedule (스케줄)
- scheduleId (Key) — BIGINT — Primary key — NOT NULL
- userId (Key2) — BIGINT — Foreign key → user.userId — NOT NULL
- fileId (Key3) — BIGINT — Foreign key → file.fileId — NOT NULL
- title (Field) — VARCHAR
- detail (Field2) — VARCHAR
- password (Field4) — VARCHAR
- date (Field5) — TIMESTAMP
user (사용자)
- userId (Key) — BIGINT — Primary key — NOT NULL
- nicknsmr (Field) — VARCHAR
- username (Field2) — VARCHAR
- password (Field3) — VARCHAR
- role (Field4) — VARCHAR
- date (Field5) — TIMESTAMP