LinkMoa-ERD

Tables (9)

Copy Of Copy Of Untitled (directory)

  • Key (directory_id(PK)) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (directory_name) — VARCHAR(60) — NOT NULL
  • Field (directory_description) — VARCHAR(150)
  • Field (parent_directory_id) — BIGINT
  • Field (order_index) — INT — NOT NULL
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME

Copy Of Untitled (directory_transmission_request)

  • Key (directory_send_request_id) — BIGINT — Primary key — NOT NULL
  • Field (receiver_email) — VARCHAR(40) — NOT NULL
  • Field (sender_email) — VARCHAR(40) — NOT NULL
  • Field (notification_type) — notification_type_enum — NOT NULL
  • Field (request_status) — request_status_enum(WAITING,REJECTED,ACCEPTED) — NOT NULL
  • Field (created_at) — DATETIME
  • Field (update_at) — DATETIME
  • Key (directory_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL

Untitled (Member)

  • Key (member_id) — BIGINT — Primary key — NOT NULL
  • Field (member_email) — VARCHAR(40) — NOT NULL
  • Field2 (password) — VARCHAR(40) — NOT NULL
  • Field3 (role) — member_role_enum(ROLE_USER,ROLE_ADMIN) — NOT NULL
  • Field4 (member_nickname) — VARCHAR(50) — NOT NULL
  • Field5 (provider) — VARCHAR(40) — NOT NULL
  • Field6 (provider_id) — VARCHAR(40) — NOT NULL
  • Field7 (member_age_range) — VARCHAR(20)
  • Field (member_gender) — member_gender_eum(FEMALE,MALE,ETC)
  • Field (member_job) — VARCHAR(50)
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME

Untitled (member_page_link)

  • Key (member_page_link_id) — BIGINT — Primary key — NOT NULL
  • Field (permission_type) — permission_type(ADMIN,HOST,EDITOR,VIEWER) — NOT NULL
  • Field2 (created_at) — DATETIME
  • Field3 (updated_at) — DATETIME
  • Key (page_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (page)

  • Key (page_id) — BIGINT — Primary key — NOT NULL
  • Key (root_directory_id) — BIGINT — Primary key — NOT NULL
  • Field (page_title) — VARCHAR(50) — NOT NULL
  • Field2 (page_description) — VARCHAR(150)
  • Field (page_type) — page_type_enum(PERSONAL,BASIC,STANDARD,PREMIUM) — NOT NULL
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME

Untitled (share_page_invitation_request)

  • Key (share_page_invite_request_id) — BIGINT — Primary key — NOT NULL
  • Field (receiver_email) — VARCHAR(40) — NOT NULL
  • Field (sender_email) — VARCHAR(40) — NOT NULL
  • Field (notification_type) — notification_type_enum — NOT NULL
  • Field (request_status) — request_status_enum(WAITING,REJECTED,ACCEPTED) — NOT NULL
  • Field (permission_type) — permission_type_enum — NOT NULL
  • Field (created_at) — DATETIME
  • Field (update_at) — DATETIME
  • Key (page_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (favorite)

  • Key (favorite_id) — BIGINT — Primary key — NOT NULL
  • Field (item_id) — BIGINT — NOT NULL
  • Field2 (item_type) — item_type_enum(SITE,DIRECTORY) — NOT NULL
  • Field3 (order_index) — INT — NOT NULL
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (site)

  • Key (site_id) — BIGINT — Primary key — NOT NULL
  • Field (site_name) — VARCHAR(60) — NOT NULL
  • Field2 (site_url) — VARCHAR(255) — NOT NULL
  • Field3 (order_index) — INT
  • Field4 (created_at) — DATETIME
  • Field5 (updated_at) — DATETIME
  • Key (directory_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL

Untitled (notification)

  • Key (notification_id) — BIGINT — Primary key — NOT NULL
  • Field (is_read) — BOOLEAN — NOT NULL
  • Field2 (notification_content) — VARCHAR(90) — NOT NULL
  • Field3 (notification_type) — notification_type_enum(TRANSMIT_DIRECTORY,INVITE_PAGE) — NOT NULL
  • Field4 (receiver_email) — VARCHAR(40) — NOT NULL
  • Field5 (sender_email) — VARCHAR(40) — NOT NULL
  • Field6 (request_id) — BIGINT — NOT NULL
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME