choom
Tables (41)
admin_session
- id — int — Primary key — NOT NULL
- admin_id — int — NOT NULL
- session — varchar(300) — NOT NULL
- reg_date — datetime
- mod_date — datetime
admin_user
- id — int — Primary key — NOT NULL
- type — enum('admin','s_admin') — NOT NULL
- name — varchar(45) — NOT NULL
- admin_id — varchar(30) — NOT NULL
- password — varchar(100) — NOT NULL
- role_id — int — NOT NULL
- country_id — int — NOT NULL
- phone_number — varchar(30) — NOT NULL
- reg_date — datetime
- mod_date — datetime
album
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- img — varchar(300) — NOT NULL
- artist — varchar(32) — NOT NULL
- song_title — varchar(100) — NOT NULL
- file — varchar(300) — NOT NULL
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
app_version
- id — int — Primary key — NOT NULL
- type — varchar(10) — NOT NULL
- version — varchar(10) — NOT NULL
- reg_date — datetime
- mod_date — datetime
branch
- id — bigint — Primary key — NOT NULL
- region_admin_user_id — int — Foreign key → region_admin_user.id — NOT NULL
- country_id — int — NOT NULL
- company_name — varchar(50) — NOT NULL
- company_representation_name — varchar(20) — NOT NULL
- company_address — varchar(100) — NOT NULL
- contact_number — varchar(20) — NOT NULL
- email — varchar(32) — NOT NULL
- status — enum('Active','Pending','Terminated') — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- reg_date — datetime
- mod_date — datetime
branch_file
- id — bigint — Primary key — NOT NULL
- branch_id — bigint — Foreign key → branch.id — NOT NULL
- file — varchar(300) — NOT NULL
- file_name — varchar(50) — NOT NULL
- reg_date — datetime
- mod_date — datetime
content
- id — bigint — Primary key — NOT NULL
- franchise_id — bigint — Foreign key → franchise.id — NOT NULL
- kiosk_id — bigint — Foreign key → kiosk.id — NOT NULL
- user_type — enum('member','guest') — NOT NULL
- user_id — bigint
- dance_type — enum('learn','reels') — NOT NULL
- album_id — int
- learn_to_dance_id — int
- video_background_id — int — NOT NULL
- video_dancer_id — int — NOT NULL
- video_frame_basic_id — int
- video_frame_megazine_id — int
- video_filter_id — int — NOT NULL
- photo_frame_basic_id — int
- photo_frame_gradient_id — int
- photo_filter_id — int — NOT NULL
- video — varchar(300) — NOT NULL
- ai_video — varchar(300)
- photo — varchar(300) — NOT NULL
- print_code — varchar(50) — NOT NULL
- del_yn_video — enum('Y','N') — NOT NULL
- del_yn_aivideo — enum('Y','N') — NOT NULL
- del_yn_photo — enum('Y','N') — NOT NULL
- down_yn — enum('N','Y') — NOT NULL
- reg_date — datetime
- mod_date — datetime
country
- id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- temp — varchar(45)
- code — varchar(10) — NOT NULL
- number — varchar(10) — NOT NULL
- currencies — varchar(100)
- currencies_code — varchar(10)
- exchange_rate — decimal(10,4)
- reg_date — datetime
- mod_date — datetime
coupon
- id — bigint — Primary key — NOT NULL
- country_id — int — NOT NULL
- type — enum('New','Event')
- name — varchar(32) — NOT NULL
- description — varchar(100)
- discount_type — enum('PERCENT','AMOUNT',"FREE")
- discount — int — NOT NULL
- start_date — datetime
- end_date — datetime
- date_set — ENUM("Y", "N")
- status — enum('Active','Terminated')
- reg_date — datetime
- mod_date — datetime
- coupon_key — INT
- max_issue_count — INT
- issued_count — INT
coupon_order
- id — bigint — Primary key — NOT NULL
- coupon_id — bigint — Foreign key → coupon.id — NOT NULL
- branch_id — BIGINT
- serial_number — varchar(20) — NOT NULL
- status — enum('Y','N') — NOT NULL
- start_date — datetime
- end_date — datetime
- reg_date — datetime
- mod_date — datetime
current_coupon
- id — BIGINT
- country_id — INT — NOT NULL
- type — ENUM('App', 'Web') — NOT NULL
- name — VARCHAR(32) — NOT NULL
- description — VARCHAR(100)
- discount_type — ENUM('PERCENT', 'AMOUNT') — NOT NULL
- discount — INT — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
- date_set — ENUM('Y','N')
- status — ENUM('Active','Terminated')
- reg_date — DATETIME
- mod_date — DATETIME
- quantity_limited_set — ENUM('Y','N')
- quantity — BIGINT
- quantity_unit — ENUM('HOUR','DAY','TOTAL')
- uuid — CHAR(36) — NOT NULL
current_coupon_order
- id — BIGINT
- coupon_id — BIGINT — NOT NULL
- serial_number — VARCHAR(20)
- status — ENUM('Y', 'N')
- start_date — DATETIME
- end_date — DATETIME
- reg_date — DATETIME
- mod_date — DATETIME
- usage_count — BIGINT
current_user
- id — BIGINT
- country_id — INT — NOT NULL
- phone_number — VARCHAR(32) — NOT NULL
- nick_name — VARCHAR(32)
- password — VARCHAR(300)
- terms_1 — ENUM('Y','N')
- terms_2 — ENUM('Y','N')
- terms_guest — ENUM('Y','N')
- version — VARCHAR(10)
- is_guest — ENUM('Y','N')
- reg_date — DATETIME
- mod_date — DATETIME
current_user_coupon
- id — INT
- user_id — BIGINT — NOT NULL
- coupon_order_id — BIGINT — NOT NULL
- reg_date — DATETIME
- mod_date — DATETIME
default_coupon
- id — BIGINT
- country_id — INT — NOT NULL
- type — ENUM('New', 'Event') — NOT NULL
- name — VARCHAR(32) — NOT NULL
- description — VARCHAR(100)
- discount_type — ENUM('PERCENT', 'AMOUNT') — NOT NULL
- discount — INT — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- date_set — ENUM('Y', 'N')
- status — ENUM('Active', 'Terminated')
- reg_date — DATETIME
- mod_date — DATETIME
default_coupon_order
- id — BIGINT
- coupon_id — BIGINT — NOT NULL
- serial_number — VARCHAR(20) — NOT NULL
- status — ENUM('Y', 'N')
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- reg_date — DATETIME
- mod_date — DATETIME
default_user
- id — BIGINT
- country_id — INT — NOT NULL
- phone_number — VARCHAR(32) — NOT NULL
- nick_name — VARCHAR(32) — NOT NULL
- password — VARCHAR(300) — NOT NULL
- terms_1 — ENUM('Y', 'N')
- terms_2 — ENUM('Y', 'N')
- version — VARCHAR(10)
- reg_date — DATETIME
- mod_date — DATETIME
default_user_coupon
- id — INT
- user_id — BIGINT — NOT NULL
- coupon_order_id — BIGINT — NOT NULL
- reg_date — DATETIME
- mod_date — DATETIME
franchise
- id — bigint — Primary key — NOT NULL
- region_admin_user_id — int — NOT NULL
- branch_id — bigint — Foreign key → branch.id — NOT NULL
- location — varchar(50) — NOT NULL
- company_representation_name — varchar(20) — NOT NULL
- contact_number — varchar(20) — NOT NULL
- email — varchar(50) — NOT NULL
- status — enum('Active','Pending','Terminated')
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- reg_date — datetime
- mod_date — datetime
franchise_file
- id — bigint — Primary key — NOT NULL
- franchise_id — bigint — Foreign key → franchise.id — NOT NULL
- file — varchar(300) — NOT NULL
- file_name — varchar(50) — NOT NULL
- reg_date — datetime
- mod_date — datetime
kiosk
- id — bigint — Primary key — NOT NULL
- branch_id — bigint — NOT NULL
- franchise_id — bigint — Foreign key → franchise.id — NOT NULL
- serial_number — varchar(30) — NOT NULL
- version — varchar(10) — NOT NULL
- detail_address — varchar(100) — NOT NULL
- on_off_status — enum('Y','N') — NOT NULL
- status — enum('Active','Pending','Terminated') — NOT NULL
- start_date — datetime
- end_date — datetime
- reg_date — datetime
- mod_date — datetime
kiosk_file
- id — bigint — Primary key — NOT NULL
- kiosk_id — bigint — NOT NULL
- file — varchar(300) — NOT NULL
- file_name — varchar(30) — NOT NULL
- reg_date — datetime
- mod_date — datetime
kiosk_product
- id — bigint — Primary key — NOT NULL
- kiosk_id — bigint — NOT NULL
- country_id — int — NOT NULL
- use_amount — decimal(10,4) — NOT NULL
- reg_date — datetime
- mod_date — datetime
learn_to_dance
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- album_group — varchar(30)
- album_title — varchar(30)
- album_level — int — NOT NULL
- album_model_name — varchar(30)
- album_model_hisotry — varchar(300)
- album_short_video_file_name — varchar(300)
- album_short_combo_img — varchar(300)
- album_guide_video_file_name — varchar(300)
- album_dance_video_file_name — varchar(300)
- album_sub_title_file_name — varchar(100)
- count — int — NOT NULL
- reg_date — datetime
- mod_date — datetime
menu
- id — int — Primary key — NOT NULL
- menu_id — int — NOT NULL
- menu_name — varchar(20) — NOT NULL
- parent_id — int
- url — varchar(45) — NOT NULL
- reg_date — datetime
- mod_date — datetime
payment
- id — bigint — Primary key — NOT NULL
- branch_id — bigint — NOT NULL
- franchise_id — bigint — NOT NULL
- kiosk_id — bigint — NOT NULL
- user_type — enum('member','guest') — NOT NULL
- user_id — bigint
- payment_type — enum('card','cash') — NOT NULL
- payment_pg — enum('PayMaya','Stripe')
- payment_link — varchar(100)
- payment_pi — varchar(100)
- coupon_order_id — int
- supply_amount — decimal(10,4) — NOT NULL
- discount_amount — decimal(10,4)
- total_amount — decimal(10,4) — NOT NULL
- pg_exchange_rate — decimal(10,4)
- pg_amount — decimal(10,4)
- pg_fee — decimal(10,4)
- pg_fee_total_amount — decimal(10,4)
- payment_in_usd — decimal(10,4)
- status — enum('Pending','Failed','Success','Expired','Refund') — NOT NULL
- reg_date — datetime
- mod_date — datetime
photo_filter
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(50) — NOT NULL
- img — varchar(300) — NOT NULL
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
photo_frame_basic
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(10) — NOT NULL
- color — varchar(30)
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
photo_frame_gradient
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(20) — NOT NULL
- color_first — varchar(10) — NOT NULL
- color_last — varchar(10) — NOT NULL
- count — int — NOT NULL
- reg_date — datetime
- mod_date — datetime
region_admin_session
- id — int — Primary key — NOT NULL
- region_admin_user_id — int — NOT NULL
- session — varchar(300) — NOT NULL
- reg_date — datetime
- mod_date — datetime
region_admin_user
- id — int — Primary key — NOT NULL
- type — enum('branch','franchise') — NOT NULL
- name — varchar(45) — NOT NULL
- admin_id — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- role_id — int — NOT NULL
- phone_number — varchar(50) — NOT NULL
- use_yn — enum('Y','N')
- reg_date — datetime
- mod_date — datetime
role_menu
- id — int — Primary key — NOT NULL
- role_id — int — NOT NULL
- menu_id — int — NOT NULL
- reg_date — datetime
- mod_date — datetime
user
- id — bigint — Primary key — NOT NULL
- country_id — int — Foreign key → country.id — NOT NULL
- phone_number — varchar(32) — NOT NULL
- nick_name — varchar(32) — NOT NULL
- password — varchar(300) — NOT NULL
- terms_1 — enum('Y','N')
- terms_2 — enum('Y','N')
- device_type — varchar(10)
- version — varchar(10)
- reg_date — datetime
- mod_date — datetime
- is_guest — enum('Y','N')
user_auth
- id — bigint — Primary key — NOT NULL
- country_id — int — NOT NULL
- phone_number — varchar(32) — NOT NULL
- auth_code — varchar(10) — NOT NULL
- reg_date — datetime
- mod_date — datetime
user_coupon
- id — int — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- coupon_order_id — bigint — Foreign key → coupon_order.id — NOT NULL
- kiosk_id — BIGINT
- reg_date — datetime
- mod_date — datetime
user_session
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- session — varchar(300) — NOT NULL
- reg_date — datetime
- mod_date — datetime
video_background
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(50) — NOT NULL
- img — varchar(300) — NOT NULL
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
video_dancer
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(30) — NOT NULL
- img — varchar(300) — NOT NULL
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
video_filter
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(50) — NOT NULL
- img — varchar(300) — NOT NULL
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
video_frame_basic
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(30) — NOT NULL
- icon_img — varchar(300) — NOT NULL
- img — varchar(300) — NOT NULL
- count — bigint — NOT NULL
- reg_date — datetime
- mod_date — datetime
video_frame_megazine
- id — int — Primary key — NOT NULL
- key_v — int — NOT NULL
- name — varchar(20) — NOT NULL
- img — varchar(300)
- count — int — NOT NULL
- reg_date — datetime
- mod_date — datetime