ㅁㄴㅇ

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