sharing-movies

Tables (5)

COLLECTION (Untitled4)

  • ID (PK) — INT — Primary key
  • USER_ID (FK) — INT — Foreign key → USER.ID — NOT NULL
  • NAME (Field) — VARCHAR
  • DESCRIPTION (Field2) — TEXT
  • CREATE_TIME (Field4) — DATETIME
  • UPDATE_TIME (Field5) — DATETIME
  • DELETE_TIME (Field6) — DATETIME

COMMENT (Untitled5)

  • ID (PK) — INT — Primary key — NOT NULL
  • COLLECTION_ID (FK) — INT — Foreign key → COLLECTION.ID — NOT NULL
  • USER_ID (FK2) — INT — Foreign key → USER.ID — NOT NULL
  • MOVIE_ID (FK3) — INT — Foreign key → MOVIE.ID — NOT NULL
  • DESCRIPTION (Field) — TEXT
  • RATING (Field5) — DOUBLE
  • CREATE_TIME (Field2) — DATETIME
  • UPDATE_TIME (Field3) — DATETIME
  • DELETE_TIME (Field4) — DATETIME

COMMENT_LIKE (Untitled6)

  • ID (PK) — INT — Primary key — NOT NULL
  • USER_ID (PK2) — INT — Foreign key → USER.ID — NOT NULL
  • COMMENT_ID (PK3) — INT — Foreign key → COMMENT.ID — NOT NULL
  • COLLECTION_ID (PK4) — INT — Foreign key → COLLECTION.ID
  • IS_LIKE (Field) — BOOL
  • CREATE_TIME (Field2) — DATETIME
  • CANCEL_TIME (Field3) — DATETIME

MOVIE (Untitled2)

  • ID (PK) — INT — Primary key — NOT NULL
  • COLLECTION_ID (FK) — INT — Foreign key → COLLECTION.ID — NOT NULL
  • NAME (Field) — VARCHAR
  • DESCRIPTION (Field2) — TEXT
  • IMAGE_PATH (Field3) — VARCHAR
  • GENRE (Field11) — VARCHAR
  • COUNTRY (Field10) — VARCHAR
  • RUNNING_TIME (Field9) — VARCHAR
  • OPENING_DATE (Field4) — VARCHAR
  • DIRECTOR (Field5) — VARCHAR
  • ACTOR (Field6) — VARCHAR
  • RATING (Field7) — DOUBLE
  • TRAILER (Field8) — VARCHAR
  • CREATE_TIME (Field12) — DATETIME
  • UPDATE_TIME (Field13) — DATETIME
  • DELETE_TIME (Field14) — DATETIME

USER (Untitled3)

  • ID (PK) — INT — Primary key — NOT NULL
  • EMAIL (Field) — VARCHAR
  • PASSWORD (Field2) — VARCHAR
  • NICKNAME (Field8) — VARCHAR
  • DESCRIPTION (Field3) — TEXT
  • IMAGE_PATH (Field4) — VARCHAR
  • CREATE_TIME (Field5) — DATETIME
  • UPDATE_TIME (Field6) — DATETIME
  • DELETE_TIME (Field7) — DATETIME