cms

Tables (9)

tb_authority (권한정보)

  • int (authority_id) — Primary key — NOT NULL
  • varchar (authority_name)

tb_board (Q&A게시판)

    tb_campaign (캠페인정보)

    • int (campaign_id) — Primary key — NOT NULL
    • varchar (campaign_name)
    • varchar (campaign_creator)
    • date (campaign_create_date)
    • int (campaign_media_list)
    • date (campaign_start_date)
    • date (camapign_end_date)
    • varchar (campaign_play_device)
    • varchar (campaign_status)

    tb_campaign_list (캠페인에 담길 영상)

    • int (campaign_list_id) — Primary key — NOT NULL
    • int (campaign_list_number)
    • int (campaign_list_media)

    tb_department (소속)

    • int (department_id) — Primary key — NOT NULL
    • varcahr (department_name)
    • varchar (department_tel)
    • varchar (department_location)

    tb_device (디바이스정보)

    • varchar (device_id) — Primary key — NOT NULL
    • null (device_location)
    • varchar (device__department)
    • varchar (device_firmware_version)
    • varchar (device_campaign_info)

    tb_media (미디어정보)

    • int (media_id) — Primary key — NOT NULL
    • varchar (media_name)
    • varchar (media_creator)
    • varchar (media_type)
    • int (media_size)
    • int (media_heigth)
    • int (media_width)
    • date (media_create_date)
    • date (media_update_date)

    tb_trash_can (휴지통)

      tb_user (유저정보)

      • varchar (user_id) — Primary key — NOT NULL
      • varchar (user_email)
      • varchar (user_pw)
      • varchar (user_name)
      • varchar (user_tel)
      • img (user_img)
      • varchar (user_department)
      • date (user_join_date)
      • varchar (user_authority)