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)