test
Tables (26)
address_seq
- next_val — bigint
business_info
- business_info_id — binary(16) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- business_city — varchar(255)
- business_street — varchar(255)
- business_zipcode — varchar(255)
- business_category — varchar(255)
- comm_created_at — datetime(6)
- comm_file_name — varchar(255)
- comm_file_url — varchar(255)
- comm_sequence — int
- comm_updated_at — datetime(6)
- business_domain — varchar(255)
- regi_created_at — datetime(6)
- regi_file_name — varchar(255)
- regi_file_url — varchar(255)
- regi_sequence — int
- regi_updated_at — datetime(6)
- business_registration_number — varchar(255)
- company_name — varchar(255)
- corporation_number — varchar(255)
- hygiene_grade — varchar(255)
- mail_order_sales_registration_number — varchar(255)
- registration_type — varchar(255)
- representative_name — varchar(255)
category
- id — bigint — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- category_color — varchar(255)
- description — varchar(255)
- name — varchar(255) — NOT NULL
- sequence — int — NOT NULL
- shop_id — binary(16)
- uuid — binary(16)
- parent_category_id — bigint
category_seq
- next_val — bigint
closed_days
- closed_days_id — binary(16) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- closed_days — bit — NOT NULL
- national_holiday — bit — NOT NULL
contract
- contract_code — varchar(255) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- contract_content — varchar(255)
- required — bit — NOT NULL
- title — varchar(255)
contract_for_shop
- contract_code — varchar(255) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- contract_content — varchar(255)
- required — bit — NOT NULL
- title — varchar(255)
feed
- feed_id — binary(16) — NOT NULL
- user_id — binary(16)
- content — varchar(500)
- created_at — datetime(6)
- deleted — bit — NOT NULL
- fix — bit — NOT NULL
- shop_id — binary(16)
- title — varchar(30)
- updated_at — datetime(6)
feed_comment
- feed_comment_id — binary(16) — NOT NULL
- user_id — binary(16)
- content — varchar(100)
- created_at — datetime(6)
- deleted — bit
- updated_at — datetime(6)
- feed_id — binary(16)
- parent_feed_comment_id — binary(16)
feed_comment_like
- feed_comment_like_id — binary(16) — NOT NULL
- user_id — binary(16)
- feed_comment_id — binary(16)
feed_feed_images
- feed_feed_id — binary(16) — NOT NULL
- created_at — datetime(6)
- file_name — varchar(255)
- file_url — varchar(255)
- sequence — int — NOT NULL
- updated_at — datetime(6)
feed_like
- feed_like_id — binary(16) — NOT NULL
- user_id — binary(16)
- feed_id — binary(16)
inquiry
- enquiry_id — binary(16) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- answer — varchar(500)
- answer_status — varchar(255)
- author_id — binary(16)
- deleted — bit
- order_id — binary(16)
- question — varchar(500)
- shop_id — binary(16)
inquiry_inquiry_images
- inquiry_inquiry_id — binary(16) — NOT NULL
- file_name — varchar(255)
- file_url — varchar(255)
- sequence — int — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
item
- type — varchar(31) — NOT NULL
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- brand_new — bit — NOT NULL
- combinable — bit
- connected_super_store — varchar(255)
- description — varchar(255)
- item_code — varchar(255)
- item_status — varchar(255)
- name — varchar(255)
- price — int — NOT NULL
- recommended — bit — NOT NULL
- sequences — int
- uuid — binary(16)
- version — bigint — NOT NULL
- item_group_id — bigint
item_group
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- name — varchar(255)
- sequences — int
- uuid — binary(16)
- version — bigint — NOT NULL
- category_id — bigint
item_item_images
- item_id — bigint — NOT NULL
- file_name — varchar(255)
- file_url — varchar(255)
- sequence — int — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
item_option_group_relation
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- uuid — binary(16)
- item_group_id — bigint
- option_group_id — bigint
item_relation_seq
- next_val — bigint
my_shop_user
- user_id — binary(16) — NOT NULL
- email — varchar(255)
- nickname — varchar(255) — NOT NULL
- persona_id — bigint
- phone_number — varchar(255)
my_shop_user_contract_relation
- my_shop_user_contract_relation_id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- accepted — bit — NOT NULL
- contract_id — varchar(255)
- my_shop_user_id — binary(16)
onsite_item
- id — bigint — NOT NULL
option
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- item_code — varchar(255)
- item_status — varchar(255)
- name — varchar(255)
- price — int — NOT NULL
- sequence — int — NOT NULL
- type — smallint
- uuid — binary(16)
- version — bigint — NOT NULL
- option_group_id — bigint
option_group
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- max — int — NOT NULL
- min — int — NOT NULL
- name — varchar(255)
- required — bit
- shop_id — binary(16)
- uuid — binary(16)
- version — bigint — NOT NULL
order_line_item_seq
- next_val — bigint
order_option_group_seq
- next_val — bigint