cms
Tables (9)
tb_authority (권한정보)
- int (authority_id) — Primary key — NOT NULL
- varchar (authority_name)
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_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)