seek_gallery
Tables (17)
archive_artwork (Archive)
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- access_date (AccessDate) — datetime — NOT NULL
- remote_addr (RemoteAddress) — varchar(15) — NOT NULL
archive_exhibition (Untitled6)
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- remote_addr (Field2) — varchar(15) — NOT NULL
artist_tag (Untitled9)
- tag (Field) — varchar(255) — Primary key — NOT NULL
- artist_id (UserID) — int — Foreign key → user.id — NOT NULL
artwork (Artwork)
- id (ArtworkID) — int — Primary key — NOT NULL
- page_id (Field3) — varchar(255) — NOT NULL
- artist_id (UserID) — int — Foreign key → user.id — NOT NULL
- name (ArtworkName) — varchar(255) — NOT NULL
- create_date (Field4) — datetime — NOT NULL
- update_date (Field5) — datetime — NOT NULL
- archive_count (ArchiveCount) — int — NOT NULL
- history_count (Field) — int — NOT NULL
- year (Year) — int — NOT NULL
- dimension (Dimension) — varchar(255)
- dimensional (Field6) — bit(1) — NOT NULL
- material (Material) — varchar(255)
- information (Information) — longtext
- color (Field2) — varchar(15) — NOT NULL
- is_video (Field7) — int
- deleted (Deleted) — bit(1) — NOT NULL
artwork_list (Untitled4)
- exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- category (Field2) — varchar(255)
comment (Comment)
- id (CommentID) — int — Primary key — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- body (Body) — longtext
- like_count (LikeCount) — int — NOT NULL
- create_ip (CreateIP) — varchar(15) — NOT NULL
- create_date (CreateDate) — datetime — NOT NULL
- last_update_ip (LastUpdateIP) — varchar(15) — NOT NULL
- delete_date (DeleteDate) — datetime
- deleted (Deleted) — bit(1) — NOT NULL
exhibition (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- owner_id (UserID) — int — Foreign key → user.id — NOT NULL
- page_id (Field3) — varchar(255) — NOT NULL
- name (Field) — varchar(255) — NOT NULL
- information (Field2) — longtext — NOT NULL
- link (Field10) — json
- create_date (Field6) — datetime — NOT NULL
- update_date (Field7) — datetime — NOT NULL
- start_date (Field11) — date
- end_date (Field12) — date
- archive_count (Field8) — int — NOT NULL
- history_count (Field5) — int — NOT NULL
- is_video (Field9) — int
- deleted (Field4) — bit(1) — NOT NULL
exhibition_collaborator (Untitled5)
- exhibition_id (UserID) — int — Foreign key → user.id — NOT NULL
- artist_id (Key) — int — Foreign key → exhibition.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- remote_addr (Field2) — varchar(15) — NOT NULL
history (History)
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- access_date (AccessDate) — datetime — NOT NULL
- remote_addr (RemoteAddress) — varchar(15) — NOT NULL
like_comment (Untitled)
- user_id (CommentID) — int — Foreign key → comment.id — NOT NULL
- comment_id (UserID) — int — Foreign key → user.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- remote_addr (Field2) — varchar(15) — NOT NULL
location (Untitled7)
- exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
- latitude (Field) — decimal(18, 15) — NOT NULL
- longitude (Field2) — decimal(18, 15) — NOT NULL
- location_id (Field3) — int
- area (Field4) — varchar(255)
love_artist (Untitled10)
- artist_id (UserID) — int — Foreign key → user.id — NOT NULL
- user_id (SessionID) — int — Foreign key → session.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- remote_addr (Field2) — varchar(15) — NOT NULL
love_exhibition (Untitled11)
- exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- remote_addr (Field2) — varchar(15) — NOT NULL
oauth (Untitled2)
- provider (Field2) — varchar(15) — Primary key — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- provider_id (Field4) — varchar(255)
represent_artwork (Untitled8)
- artist_id (UserID) — int — Foreign key → user.id — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
session (Session)
- id (SessionID) — int — Primary key — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- access_date (AccessDate) — datetime — NOT NULL
- remote_addr (RemoteAddress) — varchar(15) — NOT NULL
user (User)
- id (UserID) — int — Primary key — NOT NULL
- page_id (Field) — varchar(255) — NOT NULL
- nickname (UserNickname) — varchar(255) — NOT NULL
- account_expired (AccountExpired) — bit(1) — NOT NULL
- account_locked (AccountLocked) — bit(1) — NOT NULL
- create_ip (CreateIP) — varchar(15) — NOT NULL
- create_date (CreateDate) — datetime — NOT NULL
- withdraw_date (WithdrawDate) — datetime
- withdrawn (Withdrawn) — bit(1) — NOT NULL
- session_count (AccessCount) — int — NOT NULL
- sns (Field2) — longtext
- youtube (Field4) — longtext
- instagram (Field5) — longtext
- twitter (Field6) — longtext
- information (Field7) — longtext
- mail (Field8) — longtext
- verified (Field3) — bit(1) — NOT NULL