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