seekDB_v.0.2.0
Tables (22)
advertisement (Untitled13)
- page_id (Key) — varchar(255) — Primary key — NOT NULL
- title (Field2) — varchar(255) — NOT NULL
- subtitle (Field3) — varchar(255) — NOT NULL
artist (CopyOfCustomer Information)
- id (User ID) — int(11) — Primary key — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- person_id (ID for person) — int(11) — Foreign key → person.id — NOT NULL
- account_expired (Has the account expired) — bit(1) — NOT NULL
- account_locked (Has the account locked) — bit(1) — NOT NULL
- create_ip (IP who created the user account) — varchar(36) — NOT NULL
- last_access_ip (Last remote address IP for user account) — varchar(36) — NOT NULL
- create_date (Date when the account is created) — datetime — NOT NULL
- access_date (Date when last access has been made) — datetime — NOT NULL
- password_change_date (Last date when password has been changed) — datetime
- withdraw_date (Date when the account is withdrawn) — datetime
- password (Password for user account) — varchar(255) — NOT NULL — Hashed
- password_expired (Has the password expired) — bit(1) — NOT NULL — Expired after 6 months
- withdrawn (Has the user account withdrawn) — bit(1) — NOT NULL
artist_page (CopyOfUntitled4)
- page_id (Key) — varchar(255) — Primary key — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
- artist_id (User ID) — int(11) — Foreign key → artist.id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- username (Customer's name) — varchar(36) — NOT NULL — Duplicate accepted
- nickname (Nickname) — varchar(36) — NOT NULL — Randomly created, Duplicate not accepted
- bio (Biography) — varchar(255) — NOT NULL
- follower_number (Number of followers) — int(11) — NOT NULL
- like_count (Number of likes on total artworks) — int(11) — NOT NULL
- bookmark_count (Field) — int(11) — NOT NULL
- favorite_count (Number of selection for user's favorite artist) — int(11) — NOT NULL
- hashtag_0 (Artist hashtag 1) — varchar(36)
- hashtag_1 (Artist hashtag 2) — varchar(36)
- hashtag_2 (Artist hashtag 3) — varchar(36)
- external_link (External link for artist) — varchar(255)
- favorite_artist_page_id_0 (Key2) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
- favorite_artist_page_id_1 (Key3) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
- favorite_artist_page_id_2 (Key4) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
artwork (Untitled7)
- page_id (Key) — varchar(255) — Primary key — NOT NULL
- artist_page_id (Key2) — varchar(255) — Foreign key → artist_page.page_id — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
- artist_id (User ID) — int(11) — Foreign key → artist_page.artist_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- owner_page_id (Key8) — varchar(255) — Foreign key → user_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
- owner_id (User ID2) — int(11) — Foreign key → user_page.user_id — 10000 ~ MAX (UNSIGNED INT)
- seller_page_id (Key9) — varchar(255) — Foreign key → user_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
- seller_id (User ID3) — int(11) — Foreign key → user_page.user_id — 10000 ~ MAX (UNSIGNED INT)
- pinned_reply_id (Key6) — int(11) — Foreign key → reply.id
- form_id (Key3) — int(11) — Foreign key → artwork_form.id
- subject_id (Key4) — int(11) — Foreign key → artwork_subject.id
- style_id (Key5) — int(11) — Foreign key → artwork_style.id
- keyword_id (Key7) — int(11) — Foreign key → artwork_keyword.id
- create_ip (IP who created the artwork) — varchar(36) — NOT NULL
- last_update_ip (IP who lastly update the artwork) — varchar(36) — NOT NULL
- last_access_ip (IP who lastly access the artwork) — varchar(36) — NOT NULL — used for view count control
- create_date (Date when the artwork created) — datetime — NOT NULL
- update_date (Date when artwork updated) — datetime — NOT NULL
- delete_date (Date when the artwork has been deleted) — datetime
- last_access_date (Date of last access) — datetime — NOT NULL — used for view control
- like_count (Total number of likes) — int(11) — NOT NULL
- bookmark_count (Total number of bookmarks) — int(11) — NOT NULL
- view_count (Total number of views) — int(11) — NOT NULL
- share_count (Total number of share) — int(11) — NOT NULL
- price (Price of the artwork) — int(11) — NOT NULL
- artwork_name (Name of the artwork) — varchar(255) — NOT NULL
- type (Type of the artwork) — varchar(255) — NOT NULL — e.g. Oil on Canvas
- open_date (Date when the artwork will be available) — datetime — NOT NULL
- year (Year of the artwork) — varchar(255) — NOT NULL — Year, Country
- amount (Left amount of the artwork) — int(11) — number : amount of artworks, null : inf
- lengthX (Horizontal length of the artwork) — decimal(7,1)
- lengthY (Vertical length of the artwork) — decimal(7,1)
- lengthZ (Height of the artwork) — decimal(7,1)
- size (Field) — int(1) — NOT NULL
- font_color (Color of font used for the artwork page) — varchar(36) — NOT NULL
- artwork_class (Class of artwork) — int(1) — NOT NULL — 0 : Only One, 1 : Edition, 2 : Order-made
- sell_class (Selling status of the artwork) — int(1) — NOT NULL — 0 : Unavailable, 1 : Available, 2 : Preparing
- edition_number (Total number of editions) — int(11) — Only if the artwork is 'edition', null if it is not edition
- current_edition_number (Field2) — int(11)
- certificated (Is the artwork certificated) — bit(1) — NOT NULL
- in_resell (Is the artwork in resell) — bit(1) — NOT NULL
- deleted (Has the artwork been deleted) — bit(1) — NOT NULL
artwork_form (Untitled8)
- id (Key) — int(11) — Primary key — NOT NULL
- artwork_id (Page ID of the artwork) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
- paint (Field) — bit(1) — NOT NULL
- photo (Field9) — bit(1) — NOT NULL
- printing (Field10) — bit(1) — NOT NULL
- furniture (Field7) — bit(1) — NOT NULL
- objet (Field2) — bit(1) — NOT NULL
- accessory (Field4) — bit(1) — NOT NULL
- goods (Field6) — bit(1) — NOT NULL
- etc (Field8) — bit(1) — NOT NULL
artwork_keyword (Untitled12)
- id (Key) — int(11) — Primary key — NOT NULL
- artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
- keyword_0 (Field) — varchar(36)
- keyword_1 (Field2) — varchar(36)
- keyword_2 (Field3) — varchar(36)
- keyword_3 (Field4) — varchar(36)
- keyword_4 (Field5) — varchar(36)
- keyword_5 (Field6) — varchar(36)
- keyword_6 (Field7) — varchar(36)
- keyword_7 (Field8) — varchar(36)
- keyword_8 (Field9) — varchar(36)
- keyword_9 (Field10) — varchar(36)
artwork_style (Untitled10)
- id (Key) — int(11) — Primary key — NOT NULL
- artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
- colorful (Field) — bit(1) — NOT NULL
- monotonous (Field2) — bit(1) — NOT NULL
- minimal (Field3) — bit(1) — NOT NULL
- complicated (Field4) — bit(1) — NOT NULL
- traditional (Field5) — bit(1) — NOT NULL
- refined (Field6) — bit(1) — NOT NULL
- realistic (Field7) — bit(1) — NOT NULL
- abstractive (Field8) — bit(1) — NOT NULL
- etc (Field9) — bit(1) — NOT NULL
artwork_subject (Untitled9)
- id (Key) — int(11) — Primary key — NOT NULL
- artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
- person (Field) — bit(1) — NOT NULL
- animal (Field2) — bit(1) — NOT NULL
- fictional_character (Field3) — bit(1) — NOT NULL
- still_life (Field15) — bit(1) — NOT NULL
- scenery (Field4) — bit(1) — NOT NULL
- abstract (Field5) — bit(1) — NOT NULL
- watchword (Field6) — bit(1) — NOT NULL
- event (Field14) — bit(1) — NOT NULL
- metal (Field7) — bit(1) — NOT NULL
- wood (Field8) — bit(1) — NOT NULL
- masonry (Field9) — bit(1) — NOT NULL
- ceramic (Field10) — bit(1) — NOT NULL
- glass (Field11) — bit(1) — NOT NULL
- paper_fabric (Field12) — bit(1) — NOT NULL
- etc (Field13) — bit(1) — NOT NULL
blog (Untitled15)
- id (Key) — varchar(255) — Primary key — NOT NULL
- artist_page_id (Key2) — varchar(255) — Foreign key → artist_page.page_id — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
- artist_id (User ID) — int(11) — Foreign key → artist_page.artist_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- pinned_reply_id (Key3) — int(11) — Foreign key → reply.id
- create_ip (Field) — varchar(36) — NOT NULL
- last_update_ip (Field2) — varchar(36) — NOT NULL
- last_access_ip (Field3) — varchar(36) — NOT NULL
- create_date (Field4) — datetime — NOT NULL
- update_date (Field5) — datetime — NOT NULL
- delete_date (Field6) — datetime
- last_access_date (Field7) — datetime — NOT NULL
- like_count (Field8) — int(11) — NOT NULL
- view_count (Field9) — int(11) — NOT NULL
- share_count (Field10) — int(11) — NOT NULL
- body (Field11) — longtext — NOT NULL
- deleted (Field12) — bit(1) — NOT NULL
bookmark_artwork (CopyOfUntitled5)
- user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
- create_date (Field) — datetime — NOT NULL
confirm_email (Untitled3)
- id (Key) — int(11) — Primary key — NOT NULL
- user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL
- expire_date (Date when the email verification expired) — datetime — NOT NULL
- email (Email) — varchar(36) — NOT NULL
- provider (SNS who provided the email) — varchar(36) — none : null, naver, kakao
- salt (Salt for password) — varchar(255) — NOT NULL — Randomly generated
follow_artist (CopyOfUntitled6)
- user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- artist_id (User ID2) — int(11) — Foreign key → artist_page.artist_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- create_date (Date when following has been confirmed) — datetime — NOT NULL
follow_user (Untitled6)
- user_id (User ID2) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- follower_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- create_date (Date when following has been confirmed) — datetime — NOT NULL
like_artwork (Untitled5)
- user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
- create_date (Field) — datetime — NOT NULL
like_blog (Untitled16)
- user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- blog_id (Key) — varchar(255) — Foreign key → blog.id — NOT NULL
- create_date (Field) — datetime — NOT NULL
like_reply (Untitled14)
- user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- reply_id (Key2) — int(11) — Foreign key → reply.id — NOT NULL
- create_date (Field) — datetime — NOT NULL
log_in_user (Untitled)
- id (Key) — int(11) — Primary key — NOT NULL
- user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL
- log_in_date (Date when user account has logged in) — datetime — NOT NULL
- remote_addr (Remote address IP from client) — varchar(36) — NOT NULL
oauth_token (Untitled2)
- id (Key) — int(11) — Primary key — NOT NULL
- user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL
- access_token (Access token from SNS oauth service) — varchar(255) — NOT NULL
- provider (SNS who provided the token) — varchar(36) — NOT NULL — naver, kakao
person (Personal Information)
- id (ID for person) — int(11) — Primary key — NOT NULL
- create_date (Date when information is created) — datetime — NOT NULL
- fullname (Full name of the person) — varchar(36) — NOT NULL
- birthyear (Interval that birth year included) — varchar(36) — NOT NULL
- birthdate (Date of birth (without year)) — varchar(36) — NOT NULL
- gender (Gender (M: 0, F: 1)) — bit(1) — NOT NULL
- phone (Phone number) — varchar(36) — NOT NULL
- update_date (Last date when information is updated) — datetime — NOT NULL
reply (Untitled11)
- id (Key) — int(11) — Primary key — NOT NULL
- artwork_id (Key3) — varchar(255) — Foreign key → artwork.page_id
- blog_id (Key5) — varchar(255) — Foreign key → blog.id
- user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- user_page_id (Key4) — varchar(255) — Foreign key → user_page.page_id — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
- parent_id (Key2) — int(11) — Foreign key → reply.id
- create_ip (Field) — varchar(36) — NOT NULL
- last_update_ip (Field2) — varchar(36) — NOT NULL
- create_date (Field3) — datetime — NOT NULL
- update_date (Field4) — datetime — NOT NULL
- delete_date (Field5) — datetime
- like_count (Field6) — int(11) — NOT NULL
- body (Field7) — longtext — NOT NULL
- artist_liked (Field8) — bit(1) — NOT NULL
- deleted (Field9) — bit(1) — NOT NULL
user (Customer Information)
- id (User ID) — int(11) — Primary key — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- person_id (ID for person) — int(11) — Foreign key → person.id — NOT NULL
- account_expired (Has the account expired) — bit(1) — NOT NULL
- account_locked (Has the account locked) — bit(1) — NOT NULL
- create_ip (IP who created the user account) — varchar(36) — NOT NULL
- last_access_ip (Last remote address IP for user account) — varchar(36) — NOT NULL
- create_date (Date when the account is created) — datetime — NOT NULL
- access_date (Date when last access has been made) — datetime — NOT NULL
- password_change_date (Last date when password has been changed) — datetime
- withdraw_date (Date when the account is withdrawn) — datetime
- password (Password for user account) — varchar(255) — NOT NULL — Hashed
- password_expired (Has the password expired) — bit(1) — NOT NULL — Expired after 6 months
- withdrawn (Has the user account withdrawn) — bit(1) — NOT NULL
user_page (Untitled4)
- page_id (Key) — varchar(255) — Primary key — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
- user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
- username (Customer's name) — varchar(36) — NOT NULL — Duplicate accepted
- nickname (Nickname) — varchar(36) — NOT NULL — Randomly created, Duplicate not accepted
- bio (Biography) — varchar(255) — NOT NULL
- following_user_number (Number of users whom the user follows) — int(11) — NOT NULL
- following_artist_number (Number of artists whom the user follows) — int(11) — NOT NULL
- follower_number (Number of followers) — int(11) — NOT NULL
- favorite_artist_page_id_0 (Key2) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
- favorite_artist_page_id_1 (Key3) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
- favorite_artist_page_id_2 (Key4) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)