bktheater

Tables (4)

app_setting

  • setting_key — VARCHAR(100) — Primary key — NOT NULL
  • setting_value — VARCHAR(500)
  • reg_dt — TIMESTAMPTZ
  • mod_dt — TIMESTAMPTZ

banner

  • banner_idx — UUID — Primary key — NOT NULL
  • img_url — VARCHAR(500)
  • swipe_duration — INTEGER
  • display_order — INTEGER
  • active_yn — CHAR(1)
  • reg_dt — TIMESTAMPTZ
  • mod_dt — TIMESTAMPTZ
  • del_yn — CHAR(1)

board

  • board_idx — UUID — Primary key — NOT NULL
  • board_type — VARCHAR(50)
  • title — VARCHAR(500)
  • body — TEXT
  • author — VARCHAR(500)
  • views — INTEGER
  • best_yn — CHAR(1)
  • reg_dt — TIMESTAMPTZ
  • mod_dt — TIMESTAMPTZ
  • del_yn — CHAR(1)

performance

  • per_idx — UUID — Primary key — NOT NULL
  • per_type — VARCHAR(50)
  • category — VARCHAR(50)
  • title — VARCHAR(500)
  • title_sec — VARCHAR(500)
  • title_third — VARCHAR(500)
  • body — TEXT
  • author — VARCHAR(500)
  • img_url — VARCHAR(500)
  • views — INTEGER
  • reg_dt — TIMESTAMPTZ
  • mod_dt — TIMESTAMPTZ
  • del_yn — CHAR(1)