atumari

Tables (11)

community

  • cmty_no — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • attach — VARCHAR(255)
  • reg_date — DATETIME — NOT NULL
  • update_date — DATETIME
  • hit — INT — NOT NULL

community_comments

  • comment_no — BIGINT — Primary key — NOT NULL
  • cmty_no — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • parent_no — BIGINT — Foreign key → community_comments.comment_no
  • content — TEXT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • update_date — TIMESTAMP
  • is_deleted — INT — NOT NULL

community_files

  • file_no — BIGINT — Primary key — NOT NULL
  • cmty_no — BIGINT — Foreign key — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • save_file_name — VARCHAR(255) — NOT NULL

festival

  • festival_no — INT — Primary key — NOT NULL
  • festival_id — INT — NOT NULL
  • festival_name — VARCHAR(200) — NOT NULL
  • summary — TEXT
  • start_datetime — DATETIME
  • end_datetime — DATETIME
  • venue_name — VARCHAR(300)
  • venue_address — VARCHAR(300)
  • access_info — TEXT
  • image_url — TEXT
  • organizer — VARCHAR(300)
  • price_free — BOOLEAN
  • price_text — VARCHAR(500)
  • external_url — TEXT
  • image_source — TEXT
  • prefecture_no — INT — Foreign key → prefecture.prefecture_no
  • season — VARCHAR(20)

inquiry

  • inquiry_no — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • email — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • answer_content — TEXT
  • answered_at — DATETIME
  • password — VARCHAR(255)

inquiry_file

  • file_no — INT — Primary key — NOT NULL
  • inquiry_no — INT — Foreign key → inquiry.inquiry_no — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • stored_file_name — VARCHAR(255) — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255)
  • tel — VARCHAR(100)
  • reg_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP
  • exit_date — TIMESTAMP
  • rk — VARCHAR(100)
  • filepath — VARCHAR(5000)

member_auth

  • auth_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • password — VARCHAR(255)
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255)

notice

  • notice_no — INT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

notice_file

  • file_no — INT — Primary key — NOT NULL
  • notice_no — INT — Foreign key → notice.notice_no — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • stored_file_name — VARCHAR(255) — NOT NULL

prefecture

  • prefecture_no — INT — Primary key — NOT NULL
  • prefecture_name — VARCHAR(100) — NOT NULL
  • region_name — VARCHAR(100) — NOT NULL