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