campus-town

Tables (14)

Asset (이미지/파일)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • type (타입) — VARCHAR(255)
  • url (Field) — VARCHAR(1000)
  • program_id (Key2) — BIGINT — Foreign key → Program.id — NOT NULL

Authority (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • role_name (Field) — VARCHAR(255)
  • member_id (Key2) — BIGINT — Foreign key → Member.id — NOT NULL

Company (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • ceo_name (Field) — VARCHAR(255)
  • company_type (Field2) — VARCHAR(255)
  • contact_number (Field3) — VARCHAR(255)
  • email (Field4) — VARCHAR(255)
  • item_name (Field5) — VARCHAR(255)
  • item_type (Field6) — VARCHAR(255)
  • location (Field7) — VARCHAR(255)
  • logo (Field8) — VARCHAR(255)
  • name (Field9) — VARCHAR(255)
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

Member (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • login_id (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

Program (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • content (Field2) — VARCHAR(2000)
  • thumbnail (Field3) — VARCHAR(1000)
  • picked (Field4) — bit(1)
  • banner_rank (Field5) — INTEGER
  • category (Field6) — VARCHAR(255)
  • start_date (Field7) — DATETIME
  • end_date (Field8) — DATETIME
  • progress_date (Field9) — DATETIME
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

campus_town (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • background_color (Field) — VARCHAR(255)
  • main_color (Field2) — VARCHAR(255)
  • sub_color (Field3) — VARCHAR(255)
  • font_color (Field4) — VARCHAR(255)
  • longitude (Field5) — DOUBLE
  • latitude (Field6) — DOUBLE
  • logo (Field7) — VARCHAR(255)
  • menu_image1 (Field8) — VARCHAR(255)
  • menu_image2 (Field9) — VARCHAR(255)
  • menu_name1 (Field10) — VARCHAR(255)
  • menu_name2 (Field11) — VARCHAR(255)
  • menu_url1 (Field12) — VARCHAR(255)
  • menu_url2 (Field13) — VARCHAR(255)
  • name (Field15) — VARCHAR(255)
  • menu_summary1 (Field14) — VARCHAR(255)
  • menu_summary2 (Field16) — VARCHAR(255)
  • sub_address (Field17) — VARCHAR(255)

down_widget (Untitled8)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • url (Field2) — VARCHAR(255)
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

image (Untitled10)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • url (Field) — VARCHAR(255)
  • notice_id (Key2) — BIGINT — Foreign key → notice.id — NOT NULL

info_image (Untitled12)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • image (Field2) — VARCHAR(255)
  • map_id (Key2) — BIGINT — Foreign key → map.id — NOT NULL

inquiry (Untitled13)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • content (Field2) — VARCHAR(500)
  • answer (Field3) — VARCHAR(500)
  • is_answered (Field4) — bit(1)
  • is_secret (Field5) — bit(1)
  • user_id (Field6) — VARCHAR(255)
  • inquiry_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

map (Untitled11)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • button_name (Field3) — VARCHAR(255)
  • icon (Field5) — VARCHAR(255)
  • longitude (Field6) — DOUBLE
  • latitude (Field7) — DOUBLE
  • address (Field8) — VARCHAR(255)
  • summary (Field2) — VARCHAR(255)
  • url (Field4) — VARCHAR(255)
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

middle_widget (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • url (Field2) — VARCHAR(255)
  • image (Field3) — VARCHAR(255)
  • rank (Field4) — INT
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

notice (Untitled9)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • content (Field2) — VARCHAR(255)
  • writer (Field3) — VARCHAR(255)
  • thumbnail (Field4) — VARCHAR(255)
  • tag (Field5) — VARCHAR(255)
  • picked (Field6) — bit(1)
  • rank (Field7) — INT
  • update_time (Field8) — DATETIME
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL

up_widget (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • url (Field2) — VARCHAR(255)
  • thumbnail (Field3) — VARCHAR(1000)
  • start_date (Field4) — DATETIME
  • end_date (Field5) — DATETIME
  • campus_town_id (Key2) — BIGINT — Foreign key → campus_town.id — NOT NULL